Chart line is discontinuous

  • Thread starter Thread starter Lady Excel
  • Start date Start date
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.
 
You can set your chart options (Tools, Options, Chart tab) to treat empty
cells as not plotted (leave gaps) zero or interpolated.
 
Back
Top