Excel – How to hide 0% value in data labels in an Excel Bar Chart

chartsmicrosoft excelmicrosoft-excel-2010

I would like to hide data labels on a chart that have 0% as a value. I can get it working when the value is a number and not a percentage. I could delete the 0% but the data is going to change on a daily basis.

I am doing a if statement to calculate which column to put the data into.Data is shown below
enter image description here

I have 2 bars one green and one red. When the value is above 8% the red bar shows and when the value is below 8%. At one time i can only show one bar. I would like to hide the 0% as the bar isnt being show.

enter image description here

Best Answer

The quick and easy way to accomplish this is to custom format your data label.

  1. Select a data label.
  2. Right click and select Format Data Labels
  3. Choose the Number category in the Format Data Labels dialog box.
  4. Select Custom in the Category box.
  5. In the format code box, enter 0%;-0%; and click Add.
  6. Close out of your dialog box and your 0% labels should be gone.

This works because Excel looks to your custom format to see how to format Postive;Negative;0 values. By leaving a blank after the final ;, Excel formats any 0 value as a blank.

Related Question