Hi,

Charts plot all non numeric values as zero. There will however interpolate
values if #N/A is used.

=IF(G30,F5+G3,NA())

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Dave" wrote in message
...
How can I prevent cells with a non-numeric function result from being
plotted
as zero values. The function

=IF(G30,F5+G3,"")

Plots values as it should for G0 but when G<=0 it plots points on the
x-axis instead of omiting the points as it does when the cells are blank.
On
the spread sheet the cells display blank as they should.