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

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we need to show information in charts for our convenience. This not only helps understand a report better but also makes the report look exquisite. Pie charts are good options to represent data in graphical form. But often we have zero values in pie charts which we want to get rid of. In this article, I will show how to hide zero values in Excel Pie Chart.


Download Practice Workbook

Download this workbook and practice while going through the article.


3 Simple Methods to Hide Zero Values in Pie Chart in Excel

This is the dataset for today’s article. There are some major subjects and the number of students who have taken them respectively. Notice that, no students have taken Human Resource and Accounting. Now, I am going to prepare a pie chart hiding these values.

hide zero values in excel pie chart


1. Use Filter Feature to Hide Zero Values in Excel Pie Chart

The first method is the use of the Filter Option in Excel. In this method, we will filter the zero values to hide them. Let’s do this step by step.

Steps:

  • First of all, select the entire dataset.
  • Then, go to the Data.
  • After that, select Filter.

  • You will see that Excel has added the Filter Excel will create drop-down lists for each column.

hide zero values in excel pie chart

Now, you have to insert the pie chart. To do so,

  • Go to the Insert.
  • Then, select the pie charts. Excel will show the available ones.
  • After that, select the one you find suitable. I am going to select the 2-D.

  • Excel will create the pie chart. However, you will see that the Human Resource and Accounting subjects are still there in the Legend.

hide zero values in excel pie chart

We will hide these subjects with 0%. To do so,

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

  • Then, uncheck the box for 0.

hide zero values in excel pie chart

  • Excel will hide the zero values from the pie chart.

Read More: How to Hide Zero Data Labels in Excel Chart (4 Easy Ways)


Similar Readings


2. Create Table to Hide Zero Values in Excel Pie Chart

Now, I will discuss another method to hide zero values in Excel pie charts. We will create a table in this method instead of applying Filter. The rest is similar to method-1.

Steps:

  • First of all, select the entire dataset.
  • Then, press CTRL+T to bring the Create Table.
  • Check the box for My table has headers since there are headers in the columns.
  • Finally, click OK.

hide zero values in excel pie chart

  • Excel will create a table. You will notice that Excel has also applied the Filter option in the table.

Now, you have to insert the pie chart. To do so,

  • Go to the Insert.
  • Then, select the pie charts. Excel will show the available ones.
  • After that, select the one you find suitable. I am going to select the 2-D.

hide zero values in excel pie chart

  • Excel will create the pie chart. However, you will see that the Human Resource and Accounting subjects are still there in the Legend.

We will hide these subjects with 0%. To do so,

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

hide zero values in excel pie chart

  • Then, uncheck the box for 0.

  • Excel will hide the zero values from the pie chart.

hide zero values in excel pie chart

Read More: How to Hide Zero Values in Excel Pivot Table (3 Easy Methods)


3. Format Data Labels to Hide Zero Values in Excel Pie Chart

In this section, I will discuss another method to hide zero values from pie charts. This time, I will not use any Filter. Rather, I will format data labels to hide zeroes.

Steps:

  • First of all, insert a pie chart following method-1.

  • After that, right-click your mouse to bring up the menu.
  • Then, select Add Data Labels.

hide zero values in excel pie chart

  • Excel will add data labels.

Now, I will slightly modify the data labels to make them look clearer. For this,

  • Select the data labels.
  • Then, change the Fill color.

hide zero values in excel pie chart

  • Excel will change the Fill color. Notice that there are two 0% values.

I will now hide these 0% values. To do so,

  • Select the Data labels.

hide zero values in excel pie chart

  • Then, right-click your mouse to bring the menu.
  • After that, select Format Data Labels.

  • Now, go to Label Options.
  • Then, select the Number Category as Custom.

hide zero values in excel pie chart

  • After that, write the following format,
0.00%;;;
  • Finally, click Add.

  • Excel will hide the zero values. The final output will be like this.

hide zero values in excel pie chartRead More: How to Hide Chart Series with No Data in Excel (4 Easy Methods)


Things to Remember

  • You have to filter the dataset. Otherwise, Excel will not hide the category.
  • You can even draw a 3D pie chart if you wish.
  • Hiding zero value will keep your report short and succinct.
  • When you format data labels, the categories having zero values will remain in the Legend.

Conclusion

In this article, I have demonstrated 3 easy methods on how to hide zero values in Excel Pie Charts. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit Exceldemy for more valuable articles like this.


Related Articles

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo