Hiding Pie Slice When Value is Zero

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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
 
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,
Thanks. I see what you did. However, I was hoping to accomplish the same
thing automatically without any manual intervention (or macros).
Bob
 
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?
 
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
 
Back
Top