How do I stop zeros from plotting in Excel 2003 Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data that plots as zeros. This clutters up any trend analysis.
Without manually removing all zero (x,y) plots, I want to not see them.
 
Hi,

If the data is the result of a formula then try using NA() instead of ""
Something along the lines of

=IF(ISNUMBER(A1),A1,NA())

If not then I think more detail of your data is needed in order to
understand why it plots *AS* zero.

Cheers
Andy
 
Back
Top