How to draw continuous lines with null data?

Question

I have 5 datasets to recored the temperature and humidity at 5 different locations, and each location record it once an hour but different timing. e.g. Site-A records it at every quarter to the hour, Site-B records it at half past every hour. I appended those into 1 query. and draw the line chart and got following. Up to 15:00, there are only outside temperature so I see the line, but after that no lines show up and only dots. But I like each dataset continues smoothly, and like to see only lines in different colors to compare those.

Could someone help solve this?

Regards,

Jun

amitchandak · Answer

Anonymous , if you column is of data time type(not text), The you should be able to change axis type to continuous

anonymous · Answer

Dear amitchandak,&nbsp;Thanks for your response! My data is not a text, it's a Date/Time. So it's strange. If I remove the time from X axis or show only 1 site data,&nbsp; it shows only line.&nbsp;a) no time in X axisb) only Site-C temperature&nbsp;Regards,Jun

v-henryk-mstf · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
I did the following test and I can't seem to reproduce your problem. Is it possible to provide a test data model (with sensitive information removed) and I will answer you as soon as possible.
&nbsp;

&nbsp;

Looking forward to your reply.
Best Regards,Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.