Hi,
If it's just the data labels then try a custom number format.
Here are a few examples.
0;;;
0%;;;
0.0%;;;
If you want the zero items removed from the pie have a look at this.
http://www.andypope.info/charts/piezeros.htm
Cheers
Andy
JMarble wrote:
I have a pie chart where some of the cell values are zero, but the chart will
include all the labels. It makes the pie chart look too cluttered. How can
I not include zero value or blank cell values from appearring in the labels.
When I go to "tools", "options", and "chart", the "plot empty cells as"
area is shaded grey and I can not select options.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info