How do I hide zero values (and their titles) in a pie chart in exc

B

Bernard Liengme

A zero value will have a pie wedge of angle 0 so is invisible
To remove label (not title) click on label once, pause, click again.
Now only one label is visible; tap the DELETE key
If the value changes to a non-zero value, restore the label by right
clicking chart area; use Chart Options; one Data Labels tab check the
desired label item(s)

For an automated method you will need VBA - post your question to the Excel
programming newsgroup

best wishes
 

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

Do not display Value label if value = zero 1
How do I resize a data label box in a pie chart to stop text wrapp 1
Zero Values on a Pie Chart 2
Hiding Data Labels for 0 Values in Pie Chart 0
Why can't I add a label for each of my pie slices 1
How to stop Pie Chart from using N/A# for values 2
Hide Zero Values 1
how do i make pie chart ignore data labels where value is zero? 1

Top