0

We use both the value and percentages in the label of our charts, and I would like to know if there is a way to hide both when the value is 0. I understand how to hide it with the number format code if it's just a value or just a percentage, but I don't know how to hide it if we display both. Is it possible at all? Thanks for the help in advance!

Matthias S
  • 1

1 Answers1

0

Follow these, will help you to get rid from Zero vale.

  • Right click on Label & hit Format Data Labels.
  • Then Number & Custom.
  • Now enter the format #"" as Custom Number Format.
  • Repeat for others.
  • Now Zeros will replace with Blank.

N.B.

  • This works with all versions higher that Excel 2010.
  • If you want to display Zero then use this cell format #,##0;-#,##0.
Rajesh Sinha
  • 9,403