1

Can you please help me to understand how to hide 0% values in excel charts & at the same time, format the higher values with 1-2 decimals?

For non-percent numbers, I got the solution from another user question How can I hide 0-value data labels in an Excel Chart?

Thanks in advance!

Regards, Sk

Shetal Shah
  • 11

1 Answers1

2

Please check whether the custom format #,##0.00%;(#,##0.00%); is helpful.

enter image description here

Emily
  • 4,035