Creating Pie of Pie and Bar of Pie charts

Excel 365 2016 2010 2007 2003
If you have several parts of something whole, you can demonstrate each item in one pie chart. But, when several parts each amount to less than 10 percent of the pie, it becomes hard to distinguish the slices.
Pie of Pie Chart in Excel 2013

For example, if you have several companies that operate on the market, you can represent a part of every company on the market as a slice.

Pie Chart in Excel 2013

This data contains five slices that fall below 10%.

To make smaller slices more visible in a pie chart, Excel provides the Pie of Pie (see above) and Bar of Pie (see below) chart sub-types.

Bar of Pie Chart in Excel 2013

Each of these chart sub-types separates the smaller slices from the main pie chart and displays them in an additional pie or stacked bar chart. To create a Pie of Pie or Bar of Pie chart, follow these steps:

   1.    Select the data range (in this example B5:C14).

   2.    On the Insert tab, in the Charts group, choose the Pie button:

Charts in Excel 2013

Choose Pie of Pie Pie of Pie in Excel 2013 or Bar of Pie Bar of Pie in Excel 2013

Pie of Pie Chart in Excel 2013

   3.    Right-click in the chart area. In the popup menu select Format Data Series...

popup in Excel 2013

   4.    In the Format Data Series task pane, on the Series Options tab, select which data can displayed in second pie (in this example, in the second pie we displayed all values less than 10%):

Format Data Series in Excel 2013

You can then make any other adjustments to get the look you desire.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.