How do I not include empty cell value chart labels in pie charts?

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.

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