How to suppress zeros

  • Thread starter Thread starter Jonathan Parminter
  • Start date Start date
J

Jonathan Parminter

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

Thanks
Jonathan
 
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/
_______
 
Thanks Jon for your response. It seems strange to force an
error as a solution. But it certainly works.

Cheers
Jonathan
 
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/
_______
 
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
 
Back
Top