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

Get FREE Advanced Excel Exercises with Solutions!

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 for representing 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.


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

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: Excel Pie Chart Labels on Slices: Add, Show & Modify Factors


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: Add Labels with Lines in an Excel Pie Chart


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 Edit Pie Chart in Excel


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.

Download Practice Workbook


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


<< Go Back To Edit Pie Chart in ExcelExcel Pie ChartExcel ChartsLearn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo