Line chart even though values missing

  • Thread starter Thread starter MattBeckwith
  • Start date Start date
M

MattBeckwith

I notice that my line chart doesn't draw a line if there are missing
values.

For example, I'm charting weight by date. But if I don't weigh myself
on every single day, the line stops at the last day of a cluster of
daily weights.

Is there a way to have the dots be connected even if there are
intervening missing data points?

Thanks!
 
Hi,

If the cells are really empty the you can get the chart to interpolate
between the points. Select the chart and then use menu Tools > Options >
Chart > Plot empty cells as Interpolated.

Cheers
Andy
 
Back
Top