There are two subcategories of the Excel Pie chart. These are the Pie to Pie chart and Bar to Pie chart. When there are more entries for the Pie chart, the slice of the Pie chart becomes smaller. In that case, the subcategories make the chart more visible and presentable.
In this article, we will describe 2 methods to make Pie chart in Excel with subcategories.
Download Practice Workbook
2 Methods to Make Pie Chart in Excel with Subcategories
The following table has the Month and Profit columns. Using this table, we will make a Pie chart in Excel with subcategories. Here, we will go through 2 methods to do the task. In this article, we used Excel 365. You can use any available Excel version.
1. Using Pie of Pie Chart Feature to Make Pie Chart with Subcategories
In this method, we will use the Pie of Pie chart to make a Pie chart in Excel with subcategories.
Step-1: Inserting a Pie of Pie Chart
In this step, we will insert a Pie of Pie chart.
- First of all, select the entire data table.
- After that, we will go to the Insert tab.
- Next from Insert Pie or Doughnut Chart >> select Pie of Pie chart.
Next, you can see the Pie of Pie chart.
Step-2: Adding Data Labels to Pie of Pie Chart
In this step, we will add Category Name and Value to the Pie of Pie chart.
- In the beginning, we will click on the chart.
- Furthermore, we will click on Chart Elements, which is a Plus sign situated at the top-right corner of the chart.
- Afterward, from the Chart Elements >> click on Data Labels.
Therefore, you can see the Values in the Pie chart.
Next, we will add Category Name to the Pie of Pie chart.
- To do so, we will click on the chart.
- Moreover, from Chart Elements >> click on the rightward arrow of the Data Labels.
- At this point, select More Options.
A Format Data Labels dialog box will appear on the left side of the Excel sheet.
- Next, we will click on the Category Name under the Label Options.
As a result, you can see a Pie of Pie chart with both the Values and Category Name.
Read More: Excel Pie Chart Labels on Slices: Add, Show & Modify Factors
Step-3: Adding More Value in Second Plot
Here, the Above created Pie of Pie chart has more values in the first plot than in the second plot. Therefore, to make the chart more visible and presentable, we will add more value to the second plot.
- First of all, we will right-click on the first plot of the Pie chart.
- After that, select the Format Data Series option from the Context Menu.
Next, a Format Data Series dialog box will appear.
- Afterward, from the Series Options >> set Values in second plot to 4.
Here, you can set the Values in second plot according to your choices.
Hence, you can see that 4 slices are now present in the second plot of the Pie chart. As a result, the chart has become more visible.
Read More: How to Group Small Values in Excel Pie Chart (2 Suitable Examples)
Step-4: Formatting Pie of Pie Chart
In this step, we will format the Pie of Pie chart.
- First, we will click on the first plot of the Pie chart, and then we will click on the slice we want to format.
- After that, we will go to the Format tab.
- Next, form the Shape Style group >> select the Shape Fill option.
- Moreover, we will select a color for our selected slice.
- In the same way, we select some other slices of the first and second plots of the Pie of Pie chart, and we format those slices with a color according to our choices.
Finally, we can see the Pie chart in Excel with subcategories.
Read More: How to Format a Pie Chart in Excel
Similar Readings
- How to Make Two Pie Charts with One Legend in Excel
- How to Change Pie Chart Colors in Excel (4 Easy Ways)
- [Fixed] Excel Pie Chart Leader Lines Not Showing
- How to Create a 3D Pie Chart in Excel (with Easy Steps)
- [Solved]: Excel Pie Chart Not Grouping Data (with Easy Fix)
2. Use of Bar of Pie Chart to Make Pie Chart with Subcategories
In this method, we will use the Bar of Pie chart to make a Pie chart in Excel with subcategories.
Steps:
- First of all, select the entire data table.
- After that, we will go to the Insert tab.
- Next from Insert Pie or Doughnut Chart >> select Bar of Pie chart.
Next, you can see the Bar of Pie chart.
- After that, we add Data Labels to the Bar of Pie chart by following Step-2 of Method-1.
- Next, we add More Values to the Second plot of the Pie chart by following the Step-3 of Method-1.
- Along with that, we format the Bar of Pie chart by following the Step-4 of Method-1.
As a result, we can see the Pie chart in Excel with subcategories.
Read More: How to Make a Pie Chart in Excel (Only Guide You Need)
Multi Layering in Pie Chart
Multi-layer Pie charts are a cycle of centered circles. In this Pie chart, each item’s size reflects its donation to the interior core group. The chart begins with one or two objects at the center of the circle. A cycle of circles is set around the central circle so that the breakdown of that object can be seen properly. The Multilayer Pie Chart effectively presents the values of a ranking structure.
Here, we will use the following dataset for multilayering in a Pie chart.
Step-1: Inserting a Pie Chart
In this step, we will insert a Pie chart to make a multi layer Pie chart.
- First of all, select the entire data table.
- After that, we will go to the Insert tab.
- Next from Insert Pie or Doughnut Chart >> select Doughnut chart.
- After that, you can see the Doughnut chart.
Next, we will add a Chart Title to the Doughnut chart.
- To do so, we will click on the Chart Title and edit the Chart Title.
Step-2: Setting Doughnut Hole Size to 0%
In this step, we will make the doughnut hole size to 0%. Therefore, the chart will become a multi-layer Pie chart.
- First of all, we will right-click on the first circle of the Doughnut chart.
- After that, select Format Data Series from the Context Menu.
A Format Data Series dialog box will appear.
- At this point, from the Series Options >> set Doughnut Hole Size to 0%.
Hence, you can see a Multilayer Pie Chart.
Step-3: Highlighting Border
In this step, we will highlight the Border of the multilayer Pie chart.
- First, we will click on the middle slices of the first circle of the Pie chart.
- Then, select Format Data Series from the Context Menu.
A Format Data Series dialog box will appear.
- Next, from the Fill & Line group >> select Border.
- Afterward, click on the drop-down arrow of the color box >> select a color for the Border.
Here, we selected Black as the Border color. You can select any color according to your choices.
- In the same way, we selected the Second and Third circles and set a Border color of Black for their slices as well.
As a result, you can see the multilayer Pie chart with a Black border.
Step-4: Adding Category Name in Multilayer Pie Chart
In this step, we will add the Category Name to our Pie chart.
- In the beginning, we will click on the chart.
- Moreover, from Chart Elements >> click on the rightward arrow of the Data Labels.
- At this point, select More Options.
A Format Data Labels dialog box will appear on the left side of the Excel sheet.
- Next, we will click on the Category Name under the Label Options.
- Along with that, we unselected the Values, as we only want to see the Category Name.
Hence, we can see the Category Name in the multilayer Pie Chart.
Step-5: Formatting Multilayer Pie Chart
In this step, we will format the multilayer Pie chart to make it more presentable.
- First, we will click on the chart >> and then click on the slice we want to format.
- After that, we will go to the Format tab.
- Next, form the Shape Style group >> select the Shape Fill option.
- Moreover, we will select a color for our selected slice.
- In the same way, we select other slices of the first, second, and 3rd circles. And we add the same color to a subcategory and their product so that the chart looks more understandable.
Finally, we can see the Multilayer Pie Chart.
Read More: How to Create A Doughnut, Bubble and Pie of Pie Chart in Excel
Practice Section
You can download the above Excel file to practice the explained methods.
Conclusion
Here, we tried to show you 2 methods to make pie chart in Excel with subcategories. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below. Please visit our website Exceldemy to explore more.
Related Articles
- How to Show Percentage in Excel Pie Chart (3 Ways)
- How to Create Square Pie Chart in Excel (2 Easy Ways)
- Rotate Pie Chart in Excel (4 Useful Cases)
- How to Edit Pie Chart in Excel (All Possible Modifications)
- Make a Budget Pie Chart in Excel (with Easy Steps)
- How to Make Pie Chart by Count of Values in Excel
- How to Make a Pie Chart in Excel with One Column of Data