Perfect! This works fine, and I can make it mark the chart where there are no datapoints for a better visual.
Thanks JE
So you are saying there is no option for the default date behavior to not show a date that has no associated data point as ‘gtsafas’ has asked? This seems like a pretty simple option to have. If you are saying to use label, that means that we’d have to loop thru our data to determine the X axis values to use. Not very efficient.
Actually, it looks like what I want to do works, as long as the X axis is a Date or numeric value. It seems that the chart will sort that data accordingly so it’s in order. So, I Can work with that.
The next issue is that my data series is not a continuous range of dates. For example: 05/23/2021 – 200 05/24/2021 – 250 –I.e. weekend — 05/27/2021 – 225 05/28/2021 – 300
The chart automatically puts in the missing dates (05/25, 05/26) and then plots a 0 in those locations. I want the series to ignore the missing data and not draw the series as 200 –> 250 –> 0 –> 0 –> 225 –>300. I want it to be 200–>250–>225–>300 and ignore the missing dates.
Is there a way to do this?