Pie Chart is a circular chart that shows the data in circular slices. Sometimes, small portions of data may not be clear in a pie chart. Hence we can use the ‘pie of pie charts in excel for more detail and a clear chart. The pie of pie chart is a chart with two circular pies displaying the data by emphasizing a group of values. In Excel, there are different types of pie charts to understand. They are:
- Pie
- Exploded Pie
- Pie of Pie
- Bar of Pie
- Pie in 3-D
- Exploded Pie in 3-D
Let’s understand the Pie of Pie Chart in Excel in more detail.
Creating Pie of Pie Chart in Excel:
Follow the below steps to create a Pie of Pie chart:
1. In Excel, Click on the Insert tab.
2. Click on the drop-down menu of the pie chart from the list of the charts.
3. Now, select Pie of Pie from that list.
Below is the Sales Data were taken as reference for creating Pie of Pie Chart:
The Pie Chart obtained for the above Sales Data is as shown below:
The pie of pie chart is displayed with connector lines, the first pie is the main chart and to the right chart is the secondary chart. The above chart is not displaying labels i.e, the percentage of each product. Hence, let’s design and customize the pie of pie chart.
Designing the Pie of Pie Chart in Excel:
Follow the below steps to design a pie of pie charts:
- The design tab will be available by right-clicking on the chart.
- Click on the Design tab for creating labels and to style the chart with different colors. We can choose any chart layout and any chart style from the drop-down list of designs in excel as shown in the below figure.
Here, we have chosen the first layout for our pie of pie chart as shown below:
Changing the Data in the Secondary pie:
We can change the data that needs to be displayed in the secondary pie.
To add data in the secondary pie from the first pie, right Click on the second pie and choose Format Data Series.
Here, the data series is split by percentage value and also customized the second plot by having values less than 15%. Now the pie of pie chart is formatted as follows:
In this way, a pie of pie chart can be customized in different ways.