Do My Excel Blog: How to hide the zero percent labels in an Excel pie chart

Sunday, March 23, 2014

Remove the 0% in an Excel pie chart: Change the number format code of the labels

1) Select your chart and go to "Format Data Label":

On Excel 2013: click on the "+" sign that appears on the top right of the chart and click on the arrow next to "Data Labels":

On Excel 2007: go to the menu "Chart tool" > "Format", select "Label format" and "Custom".

2) Go to the section "Number" and add a new "Format Code": Type:

0%;0%;;;

3) As a result, you won't see the 0% values in your chart:

There are many other things you can do with the "Number Format Code" like changing colors of the labels, changing label format, etc. More info here