View Single Post
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

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