How do I not include empty cell value chart labels in pie charts?

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

Guest

I have a pie chart where some of the cell values are zero, but the chart will
include all the labels. It makes the pie chart look too cluttered. How can
I not include zero value or blank cell values from appearring in the labels.

When I go to "tools", "options", and "chart", the "plot empty cells as"
area is shaded grey and I can not select options.
 
Back
Top