Chart line is discontinuous

L

Lady Excel

Hello,

A similar problem to my last. I have entered data from reading sheets and
not every date/time has a data point. I have noticed that if there is no
date/time the chart does not draw the line between data points. Please help
me out with this.
 
A

AltaEgo

You can set your chart options (Tools, Options, Chart tab) to treat empty
cells as not plotted (leave gaps) zero or interpolated.
 
Top