Hi,

You could use conditional formatting to display the cells contents in
the same colour as the cells fill colour.

Cheers
Andy

Bill H. wrote:
OK, but then the column with the formula displays #N/A instead of (what I
had before) a space.

Can the display of #N/A be set to not show in the cells?

--Bill

"Andy Pope" wrote in message
...

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





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info