Circular Graphic without Zeros in data label

[kalcerro_1]

Hello Everyone!

I have two graphics that are auto-generated when a tab appears in the excel workbook (appears generated by a macro runned by the user). These graphics will have sometimes values in Zero, values without any results, but somehow, these zeros always appear in the graphic, I have tried with different methods, advanced options in excel workbooks, changing the values in the data, using the if formula, but the zeros always appear in the data label. Picture attached of what I'm getting.
Is there a method, not using pivot tables, that can help me to hide automatic these zeros?

Best regards,

Karin.

 

[pgc01]

Hi Karin

You can format the number value in the labels

- right-click on one label and choose Format Data Labels->Number
- select Custom
- in the format box write: 0%;;
- click on the button Add

This should clear the 0% values. If you still have leader lines right-click on one of them, choose Format Leader Lines and select No Line.

 

[kalcerro_1]

Hi Karin

You can format the number value in the labels

- right-click on one label and choose Format Data Labels->Number
- select Custom
- in the format box write: 0%;;
- click on the button Add

This should clear the 0% values. If you still have leader lines right-click on one of them, choose Format Leader Lines and select No Line.

Thank you @pgc01 that worked perfectly, Now I have a doubt, what happen if this is Automatic and the label contains text: Consumable 0%, I deleted the 0% but not the text, is there a format for text and numbers? And what happen when a new set of values is loaded? It will appear again?

Thank you again for your support. I've trying to find this in Microsoft Forums, with no success.

Karin.