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

  • Thread starter Thread starter deeds
  • Start date Start date
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
 
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
 
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
_______
Click to expand...
 
Back
Top