If you are searching for the solution or some special tricks to make a Pie of Pie Chart in Excel then you have landed in the right place. There is a quick way to make a Pie of Pie chart in Excel. This article will show you each and every step with proper illustrations so, you can easily apply them for your purpose. Let’s get into the central part of the article.
What Is a Pie of Pie Chart?
Pie of Pie Chart is mainly a Pie chart under which there will be a secondary Pie chart. Basically, when a Pie Chart contains lots of categories of data then it becomes so difficult to identify the data. Then the Pie of Pie chart separates some small slices of the primary Pie chart to a secondary pie chart. So, you must use the Pie of Pie Chart when there is a lot of data. An example is given below.
How to Make Pie of Pie Chart in Excel: 4 Steps
In this section, I will show you 4 quick and easy steps to make a Pie of Pie chart in Excel. Moreover, you will find detailed explanations of the steps here. In addition, I have used the Microsoft 365 version here. However, you can use any other versions as of your availability. If any steps won’t work in your version then leave us a comment.
In addition, for your better understanding, I will use a sample dataset. Which contains 2 columns. They are Product and Sales.
Step-01: Inserting Pie of Pie Chart in Excel
- Firstly, you must select the data range. Here, I have selected the range B4:C12.
- Secondly, you have to go to the Insert tab.
- Now, from the Insert tab >> you need to select Insert Pie or Doughnut Chart.
- Then, from 2-D Pie >> you must choose Pie of Pie.
At this time, you will see the following Pie of Pie Chart.
Step-02: Applying Style Format
You can not only create the Pie of Pie Chart but also can format the chart to make it more attractive. Here, I will show the style format of the Pie of Pie Chart. Let’s start with the steps.
- Firstly, you have to select the Chart.
- Secondly, you may click on Brush Icon.
- Thirdly, from the Style feature >> select the preferable style. Here, I have selected the 11th style.
Subsequently, you can see the changes.
Read More: How to Make a Pie Chart in Excel
Step-03: Applying Color Format in Pie of Pie Chart
Now, I will use color formatting for the chart.
- Firstly, under the Brush icon >> select the color feature.
- Secondly, you have to choose your preferable color. Here, I have chosen the 2nd option under the Colorful option.
Read More: How to Create & Customize Bar of Pie Chart in Excel
Step-04: Employing Data Labels Format
You can also make changes to data labels. Which will make your information more visual.
- At first, you have to click on the + icon.
- Then, from the Data Labels arrow >> you need to select More Options.
At this time, you will see the following situation.
- Now, from the Label Options choose the parameters according to your preference. Here, I have added a Category Name. Percentage and Show Leader Lines are auto-selected. Also, I have selected Label Position as Inside End.
Finally, you will see the formatted Pie of Pie Chart.
Read More: How to Make Multiple Pie Charts from One Table
Alternative Way to Format Pie of Pie Chart Using Custom Ribbon
You can format the Pie of Pie Chart using an alternative option such as Custom Ribbon.
The steps are given below.
Steps:
- Firstly, you have to select the Pie of Pie Chart.
- Secondly, you must go to Chart Design Ribbon.
- Now, you can choose the design format of your preference. Here, I have chosen the 11th style.
- Then, you can change the colors under the Change colors Ribbon. Here, I keep the auto-generated color.
- In addition, for formatting the data labels under the Format Ribbon, you have to select the Data Labels feature.
- Firstly, you need to go to Format Ribbon.
- Secondly, from the Current Selection Ribbon >> you must select the Series “Sales” Data Labels.
At this time, you will see the following situation.
- Now, you need to choose the Label Options from the Format Data Labels.
- Now, you will select your preferences. Here, I have selected Category Name and Percentage from the Label Contains and chosen Best Fit from the Label Position.
Finally, you will see the following result.
Read More: How to Make a Multi-Level Pie Chart in Excel
Expand a Pie of Pie Chart in Excel
You can do an interesting thing with a Pie of Pie Chart in Excel. Which is explode of the Pie of Pie Chart in Excel. The steps to expand a Pie of Pie Chart are given below.
Steps:
- Firstly, you must select the data range. Here, I have selected the range B4:C12.
- Secondly, you have to go to the Insert tab.
- Now, from the Insert tab >> you need to select Insert Pie or Doughnut Chart.
- Then, from 2-D Pie >> you must choose Pie of Pie.
At this time, you will see the corresponding Pie of Pie Chart.
Furthermore, you can format the chart. Here, I have changed the chart style using the Brush icon.
Similarly, I have changed the chart color using the Color feature under the Brush icon.
- Now, you need to click on the Pie and drag any slice.
Finally, you will see the following result.
Read More: How to Create a 3D Pie Chart in Excel
Things to Remember
- If you delete any entry from the data range, that will also delete from the chart. However, the symbol under the Legend Options will remain.
Practice Section
Now, you can practice the explained method by yourself.
Download Practice Workbook
Conclusion
I hope you found this article helpful. Here, I have described how to make a Pie of Pie Chart in Excel. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
Related Articles
- How to Make a Gender Pie Chart in Excel
- How to Create Square Pie Chart in Excel
- How to Make a Budget Pie Chart in Excel
<< Go Back To Make a Pie Chart in Excel | Excel Pie Chart | Excel Charts | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
