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


"Sandy" wrote:

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...t/PieChart.xls
I have uploaded the simple chart I tested.

Sandy

"Bob" wrote in message
...
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" wrote:

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" wrote in message
...
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