How to suppress zeros

[Jonathan Parminter]

Hi,
I have data that includes zero values. How do I stop these
zero values being plotted on a chart?

Thanks
Jonathan

 

[Jon Peltier]

Jonathan -

You can replace the zeros by blanks, if they are not the result of a
formula in the cell. This means clear the cell, select it and press
Delete. "" won't do it, because it isn't a blank, it's a rather short
text string.

If the 0 is from a formula, replace it by NA(), which gives you the #N/A
error in the worksheet. the formula will have to look like this:

=IF(<something>=0,NA(),<something>)

If the error values in the cells bothers you, use conditional formatting
to hide them. Debra Dalgleish describes the process here:

http://contextures.com/xlCondFormat03.html#Errors

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jonathan Parminter]

Thanks Jon for your response. It seems strange to force an
error as a solution. But it certainly works.

Cheers
Jonathan

 

[Jon Peltier]

Jonathan -

Glad to help. As an engineer, I don't care too much how something works.
The more important feature is that is does work.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Tushar Mehta]

Don't consider NA() as an error, but as 'Not applicable.'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions