Automatically eliminating zero-value data labels from charts

Question

Automatically eliminating zero-value data labels from charts

Anonymous

I have a pie chart drawn from the following data:

Item A: 10

Item B: 0 (in place as I might expect some value at a later time)

Item C: 30

Item D: 60

I did away with the legend in favor of data labels on each slice of the pie, showing percentages. So Excel generates:

"Item A 10%"

"Item B 0%" (along with a paper-thin slice of the pie)

"Item C 30%"

"Item D 60%"

Other than not selecting Item B in my charting range, is there a way to prevent the data label and paper-thin pie slice for this zero-value item from appearing in the chart?

Thanks in advance,

--Eric

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

5 additional answers

Answer 1

Anonymous

if you use formula =NA() instead of the holding zero the slice and data label will not appear.

0 comments

Answer 2

Anonymous

Please view screen capture

best wishes

0 comments

Answer 3

Anonymous

Follow these steps:

Click on Format Data Labels -> Number -> Custom -> #,##0;-#,##0;; -> Add

New chart is ready for use:

0 comments

Answer 4

Anonymous

@Ashok, That works if the data label displays Percentage only.

Try it where Category or Value are displayed.

The OP's question would suggest they are display both Category and Percentage in the data label.

"Item A 10%"

0 comments

Answer 5

Anonymous

Interestingly Excel 2013 does not show a "paper-thin pie slice" or a data label for a zero-value item.

That's an improvement - if you like pie charts.

best wishes

0 comments

Share via

Automatically eliminating zero-value data labels from charts

5 additional answers