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".
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
