Hide items w/a 0 value in a chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Can a pie of pie chart use animation/transitions? 1
Pie charts - 0 values 2
Excel Graphing 3
Show Total In a Text Box in a Pie Chart 2
Excel Charts 1
Display one cell as a pie chart 2
Having a pie chart ignore data fields equal to "0" 1
Pie Chart Question 1

Back
Top