Pie of Pie Chart in Excel

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).

MonthNumber of Units
January65000
February67000
March44667
April34359
May24542
June21719
July43437
August21719
September12776

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 1

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 2

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 3

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

pie of pie chart in excel 4

You can also customize the split according your needs

So the final Excel pie of pie chart  will be like

pie of pie chart in excel 5

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

pie of pie chart in excel 6

So the final Bar of Pie chart in Excel will be likepie of pie chart in excel 7

 

previous small pie of pie chart in excel                                                                                                                next small pie of pie chart in excel