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

[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

 

[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

 

[deeds]

Thanks! Works great.

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
_______