Creating Pie of Pie and Bar of Pie charts

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.

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.

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:

Choose Pie of Pie or Bar of Pie

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

   4.    In the Format Data Series dialog box, 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%):

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