In this tutorial we will learn how to create pie of pie chart in Excel and Bar of Pie chart in Excel.
Why we use Pie of Pie chart in Excel ?
When we need to represent the percentage distribution across categories we generally use Pie chart. When there is too much of categories with very less percentage distribution then the pie chart becomes quite messy. In that case we use Pie of Pie chart which Projects those values which is less than the threshold as a separate pie chart.
Data that we use to demonstrate Pie of Pie chart in Excel is shown below (number of units produced across months).
Month | Number of Units |
---|---|
January | 65000 |
February | 67000 |
March | 44667 |
April | 34359 |
May | 24542 |
June | 21719 |
July | 43437 |
August | 21719 |
September | 12776 |
Lets see how to create Pie of Pie chart in Excel.
Pie of Pie chart in Excel Step 1 :
Select the data, click Insert tab > chose pie chart ribbon >Pie of pie chart as shown below
Pie of Pie chart in Excel Step 2:
From the chart styles chose the style of charts that suits our representation. So our chart will be like.
Pie of Pie chart in Excel Step 3:
Right click on any area of the Pie chart and Chose Format Data series option .you can change the way the pie has been split by clicking the Split series by option as shown below.
Right now it is split by last 3 months(July, August, September)
Pie of Pie chart in Excel Step 3A:
you can change it to percentage value with values less than 10 % in separate pie as shown below
You can also customize the split according your needs
So the final Excel pie of pie chart will be like
Bar of Pie chart in Excel:
Similarly you can create the bar of Pie chart by following the above procedures or simply click on the pie of pie chart and click on insert tab -> Bar of Pie cart as shown below
So the final Bar of Pie chart in Excel will be like