Pie or Pie of Bar of Pie charts are using when you have a lot of data, where some of them are much smaller in value compared to the others.

You want to create a pie chart of data of customer-wise sales, data as below.

Simple Pie Chart

Simple Pie Chart

Notice that Customer nos. 8, 9, 10, 11, 12, 13 have much lesser sales than the other customers.
Thus, the size of the slices of these customers are very small and not identifiable well in the chart.

What we can do is, consolidate all low sales customers into 1 single slice, and then split that slice into another pie chart to explain the data better.

This is called Pie of Pie chart in Excel.

Creating Pie of Pie chart

  1. Sort the sales data in descending order of sales.
    • Select the data.
    • In Data tab, select Sort.
    • Sort by Sales, Largest to Smallest.

      Sort data in descending order

      Sort data in descending order

  2. Create a Pie of Pie chart.
    • Select the data.
    • In Insert Tab, Pie chart, select Pie of Pie.
      Create Pie of Pie chart

      Create Pie of Pie chart

      Pie of Pie chart created

      Pie of Pie chart created

  3. Choose number of customers to be in the 2nd pie chart.
    • Select the pie chart.
    • Right-click and go to Format Data Series.
    • Second plot contains the last ____ values. Enter 6 here.

      Second plot contains the last 6 values

      Second plot contains the last 6 values

  4. Turn off the Legends from Layout tab.
  5. Insert Chart Title from Layout tab.
  6. Add Data Labels.
    • Right-click the chart, Add data labels.
    • Right-click the chart, Format data labels.
    • Tick on Category Name, you may keep or remove the tick on Value. I have removed it here.
  7. Aesthetic changes.
    • Right-click the chart, Format data series.
    • Fill – White solid color.
    • Border color – Black solid color.
    • ShadowPresets, Outer 1st option.
    • Format only the “Other” slice.
      • Select the chart.
      • Then click on only the Other slice.
      • Right-click, format Data Point.
      • Fill – Solid Black color.
      • Select the data label of Other only and make the font color White.
Final Chart

Final Chart

 

Similarly, you can also create a Bar of Pie chart.

Bar of Pie chart

Bar of Pie chart