I am using a pie chart with names as the values descriptions and then the
percentage. I have some names, currently, that have a 0 value. How can I
make the pie chart automatically hide the names that have a 0 value?
I am using a pie chart with names as the values descriptions and then the
percentage. I have some names, currently, that have a 0 value. How can I
make the pie chart automatically hide the names that have a 0 value?
AFAIK, you can't. You could use =IF(value=0,"",desciption) to have no text
in the legend, but its color would still show. You could manually delete
the legend entry, but that is not automatic. The closest you can come is to
write VBA code to a change event that would restore the legend and then
delete entries that correspond to zero values; it would take some work, but
is doable.
Jerry
"NUMBnut" wrote:
> I am using a pie chart with names as the values descriptions and then the
> percentage. I have some names, currently, that have a 0 value. How can I
> make the pie chart automatically hide the names that have a 0 value?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks