Line chart even though values missing

[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!

 

[Andy Pope]

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