Don't show zeros or #N/A in Column Chart


D

deeds

I have read all of the posts referring to replacing the "" to NA() and it
will then display #N/A which the chart will ignore. Not in a column chart.
How do I hide the zeros or #N/A in a column chart?

Thanks
 
Ad

Advertisements

J

Jon Peltier

For a column chart, keep the data as "" or zero, and apply a number format
to the data labels that suppresses zeros. That means, if your number format
is 0.00, use a more elaborate one like

0.00;-0.00;;

The number format can have four terms, separated by semicolons. The first
term is usually for positive numbers, the second for negative, the third for
zero, the fourth for text. Any missing element means that element's items
will not be displayed.

- Jon
 
Ad

Advertisements

D

deeds

Thanks! Works great.

Jon Peltier said:
For a column chart, keep the data as "" or zero, and apply a number format
to the data labels that suppresses zeros. That means, if your number format
is 0.00, use a more elaborate one like

0.00;-0.00;;

The number format can have four terms, separated by semicolons. The first
term is usually for positive numbers, the second for negative, the third for
zero, the fourth for text. Any missing element means that element's items
will not be displayed.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top