How to Hide Zero Values in Excel Pie Chart (3 Simple Methods)

In the sample dataset, we have a list of major subjects and the number of students who have taken them. No students have taken Human Resources and Accounting. We’ll prepare a pie chart which hides these values.

Method 1 – Use the Filter Feature to Hide Zero Values in a Pie Chart

Steps:

Select the entire dataset.
Go toData.
Select Filter.

Excel has added drop-down lists for each column.

Go to Insert.
Select pie charts.
Select the 2-D Pie Chart.

Human Resources and Accounting subjects are still there in the Legend.

Select the drop-down box for the column % of Students.

Uncheck the box for 0.

Excel will hide the zero values from the pie chart.

Method 2 – Create a Table to Hide Zero Values in a Pie Chart

Steps:

Select the entire dataset.
Press Ctrl + T to bring up Create Table.
Check the box for My table has headers since there are headers in the columns.
Click OK.

Excel will create a table and has applied the Filter option in the table.

Go to Insert.
Select the pie charts. We picked a 2D Pie Chart for convenience.

Human Resources and Accounting subjects are still there in the Legend.

Select the drop-down box for the column % of Students.

Uncheck the box for 0.

Excel will hide the zero values from the pie chart.

Method 3 – Format the Data Labels to Hide Zero Values in a Pie Chart

Steps:

Insert a pie chart.

Right-click on the chart.
Select Add Data Labels.

Excel will add data labels.

Select the data labels.
Change the Fill color.

Notice that there are two 0% values.

Select the Data labels.

Right-click on the labels.
Select Format Data Labels.

Go to Label Options.
Select the Number Category as Custom.

Use the following format:

0.00%;;;

Click Add.

Excel will hide the zero values.

Read More: How to Edit Pie Chart in Excel

Things to Remember

You have to filter the dataset. Otherwise, Excel will not hide the zero values.
You can even draw a 3D pie chart if you wish.
When you format data labels, the categories having zero values will remain in the Legend.

Download the Practice Workbook

Hide Zero from Pie Chart.xlsx