View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph
 
Posts: n/a
Default How can I not graph a 0 value.

"jbd" wrote in message
...

Thanks. I tried the "do not plot" and it worked great if my cells were
empty, however, the cells that my source data covers are formulas and
the graph is reading the formulated cells as 0 and charting it. Any
suggestions on how I can make my formulas appear to be empty so my
graph won't chart it?


Try to get the formula to return NA(), rather than zero or a blank.
--
David Biddulph