Pie Chart not to display 0 Values

  • Thread starter Thread starter Khawar
  • Start date Start date
K

Khawar

Good day,

I have an excel Table something like below.

Column A Column B
Item 1 24%
Item 2 13%
Item 3 0%
Item 4 3%
Item 5 0%

The Values in Column B are being automatically updated from another table.
There are 24 Items in the table and usually about 10 of them are 0, in a
given period of time.

Is there any way that the chart can be intelligent enough to skip the 0
Values and display only values greater than 0.
This would clear the clutter on the chart.

I am using a pie chart for the purpose.

Thanks for Help
_________________
Best Regards
Khawar
 
If your labels are only showing the value or percentage, you can do this
very simply by changing the number format of the labels. Select the data
labels, press CTRL+1 to format them (or choose Selected Object from the
Format menu). Click on the Number tab, select Custom in the list on the
left, and enter a custom format like one of these in the box on the right:

0;;;
0%;;;
0.0%;;;

The custom formats consist of a string of four formats, separated by
semicolons. The four entries by default are for positive, negative, and
zero values, and for text strings. Any which are left out do not appear,
so the entries above only show positive values.

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