Hi,

Select the chart and then via Tools Options Chart Plot empty cells as
Interpolated.

But this will only may a difference if you cells are truly empty. If they
contain formula or text that setting will have no effect.
Instead you need to use NA() instead of ""

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Co" wrote in message
...
Hi All,

I found this spreadsheet on the net:
http://spreadsheets.google.com/ccc?k...k_rZ_TXRU7KIg#

It is a log for runners. The chart displays only the days that contain
some data.
Those are the days that a person did a run.
I'm tried this on my own chart but it always comes up with the line
dropping to zero
value when no data was found on that day.

How is this done?

Regards
Marco