Hi,
I would like to know if there is any way to skip the plotting of graph for missing data. My x-axis is of shortdate and y-axis is numeric. The values on the x-axis range from 9/1 to 10/9. my step value on x-axis is 1 day so it plots 1 gridline for each point(1 day). Now, my dataset does not have any items with values for certain dates but it still gets plotted on the x-axis because of the min and max values given to x=axis. Is there any way to suppress the plotting of this x-axis label, if the data set doesn't contain the data? Also, the labels overlap. The date range is 9/5 - 10/9 Attaching chart for your ref.
Thanks.
I would like to know if there is any way to skip the plotting of graph for missing data. My x-axis is of shortdate and y-axis is numeric. The values on the x-axis range from 9/1 to 10/9. my step value on x-axis is 1 day so it plots 1 gridline for each point(1 day). Now, my dataset does not have any items with values for certain dates but it still gets plotted on the x-axis because of the min and max values given to x=axis. Is there any way to suppress the plotting of this x-axis label, if the data set doesn't contain the data? Also, the labels overlap. The date range is 9/5 - 10/9 Attaching chart for your ref.
Thanks.