Thread: Line chart even though values missing

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

MattBeckwith wrote:
> 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, Microsoft MVP - Excel
http://www.andypope.info