Hiding Pie Slice When Value is Zero

[Bob]

My data labels contain the Value and Percentage. I can hide the Value of a
slice (when its value=0) when I set its format to ;000. But I can't figure
out how to not display the slice since the data label Percentage still shows
up as 0%.
Any help would be greatly appreciated.
Thanks,
Bob

 

[Sandy]

Why not just filter the data (showing only >0) and use the entire
(unfiltered) range as source data.
The chart will not show hidden values - only the filtered values.
Sandy

 

[Bob]

Sandy,
Thanks for the suggestion. Unfortunately, since I have selected the
Percentage checkbox for Data Labels (which I need to show), Excel still shows
"0%" when the pie slice's value is zero.

What I'm trying to figure out is how to not have the "0%" be displayed and
the corresponding pie slice not displayed when the pie slice's value is zero.

Bob

 

[Sandy]

Bob
I have tried setting up a Pie Chart in the way you are describing with the
"Percentage" checkbox selected in Data Labels and it works fine for me
(unless I am at total cross purposes).
Have a look here
http://www.webstruct.co.uk/webstruct/piechart/PieChart.xls
I have uploaded the simple chart I tested.

Sandy

 

[Bob]

Sandy,
Thanks. I see what you did. However, I was hoping to accomplish the same
thing automatically without any manual intervention (or macros).
Bob

 

[TJ]

Have you tried setting the format to Custom, with '0%;;;' (three semicolons
following the formatting)? This is for the data labels only and will hide the
0% values you are referring to.

I am having a similar issue that I cannot solve. I am trying to keep data
labels that have blank values from showing up in the chart. I also would like
to do this automatically as the data I am using can change frequently. I have
two columns but not every row with a name in column A has a value in column
B. The cells are blank, and those that fall into this category still show up
in the pie chart as name-only. Because I have my formatting set as described
above there are no 0% values showing up, but I cannot figure out how to get a
non-value label to not show up without deleting it manually. Does anyone know
of a way this can be done?

 

[Bob]

TJ,

Yes, I set the Custom format to '0%;;;' and that seemed to do the trick. As
far as blanking out the data label when the corresponding value is 0%, I
wrote a simple formula in the cell containing the data label:

Assume cell A1 = data label = "Widgets Sold"
Assume cell B1 = data value = 0%

In cell A1, input =IF(B1=0,"","Widgets Sold")

Bob