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!


--
MattBeckwith


------------------------------------------------------------------------
MattBeckwith's Profile: http://www.excelforum.com/member.php...o&userid=30571
View this thread: http://www.excelforum.com/showthread...hreadid=502199