View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Omit points from plot if cell is formula returns a non-numeric res

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.