Hi,

You need to adjust your formula so it evaluates to #N/A rather than zero.

=IF( <test , <value , NA() )

Line charts will not display markers for #N/A and the line is interpolated
between valid points.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Bill H." wrote in message
...
Have a line chart covering many cells. Data is added to each cell daily.
The data cells use a formula. Problem is, the formula evaluates to zero
without a value in the formula's source cell. Thus, the line chart, for
future values, goes to zero.

Is there a way to have the line on the chart simply "end" without showing
zero out to the end of the data range?

Thx.

--
Bill