View Single Post
  #1   Report Post  
Phil Lavis
 
Posts: n/a
Default How to ignore zero values when plotting a graph

Using Excel 2003. I have a data range for a graph. The values in the cells
are the results of a simple If function - If(m280,n28,0). The results are
taken from a larger data input exercise. But, the graph line (a simple
graph!) plots the FALSE value (0) when I would like there to really be no
value & hence no plotted point if the result is FALSE.