A pie of pie chart pulls the smallest slices of a crowded pie into a second, smaller pie on the right. Crowded pies are common: 16.3% of the 20,428 charts downloaded from this site had more than seven slices, the point where Microsoft says a pie gets hard to read.
Updated November 22, 2026
To make a pie of pie chart in Excel, select your labels and numbers, then click Insert > Insert Pie or Doughnut Chart > Pie of Pie. Excel moves the three smallest values into a second pie on the right. To change which slices move, right-click a slice, open Format Data Series and set Split Series By to Position, Value or Percent value.
One column of category names, one column of numbers, one row per slice. Microsoft's pie guidance is one data series with no zero or negative values. Sorting the numbers largest to smallest keeps the smallest rows together, which makes it easier to check which ones Excel moved.
Select the two columns first, then open the pie button on the Insert tab and pick Pie of Pie (or Bar of Pie for a stacked bar on the right). Already made a plain pie? Select it and use Chart Design > Change Chart Type instead.
Unless you tell it otherwise, Excel puts the three smallest values in the second pie and replaces them in the main pie with one combined slice. The main pie is always on the left and the second on the right; Excel won't swap them.
Right-click a slice and choose Format Data Series. Pick Position and type a number in Values in second plot, or pick Value or Percent value and type a threshold in Values less than.
In the same pane, look for the second plot size setting, which sets the right-hand pie as a share of the main one (Excel accepts 5 to 200), and the gap width setting for the space between them (0 to 500). As a rule of thumb of ours, a second pie at about half to three quarters of the main one stays readable.
Use the Chart Elements button (the plus beside the chart) to turn on data labels, then show Category Name and Percentage. Click the combined slice's label twice and type a name your reader understands, such as Small costs, in place of the default Other.
Microsoft notes the label percentages are rounded and may not total 100. Fix it by changing the decimal places for percentages on the Number tab of the Format Cells box (Home tab > Number group > Dialog Box Launcher).
Right-click any slice and choose Format Data Series. These are the settings that decide what lands in the second pie and how it looks. Bar of Pie uses the same ones; only the second section is a stacked bar.
| Setting | What it does | What to enter |
|---|---|---|
| Split Series By: Position | Moves the number of values you enter into the second pie | Values in second plot: how many, such as 3 if you want the 3 smallest (Microsoft's own example) |
| Split Series By: Value | Moves every value below a number you pick | Values less than: a number in your data's units, such as 2000 |
| Split Series By: Percent value | Moves every slice below a share of the total | Values less than: a percentage, such as 5% to catch slices of 3%, 3% and 4% |
| Moving one slice by hand | Microsoft's VBA reference documents moving a single point to the second section (Point.SecondaryPlot) | Microsoft's help page does not describe a menu for this, so check Split Series By in your version for a custom option |
| Second plot size | Size of the second pie as a percentage of the main pie (the SecondPlotSize property) | 5 to 200 |
| Gap width | Space between the main pie and the second pie (the GapWidth property) | 0 to 500 |
Sources: Microsoft Support, Explode or expand a pie chart (Position, Value, Percent value and their boxes), and Microsoft's Excel VBA reference for the same settings (SecondPlotSize 5 to 200, GapWidth 0 to 500, Point.SecondaryPlot for moving one point). Microsoft's help page does not name the Second plot size and Gap width boxes, so look for those settings in the same pane. All read November 22, 2026.
The most common reason people try pie of pie is to open up one slice, such as a Living Room budget split into TV, bench and carpet. Excel can't do that on its own: the second pie is filled from the same list as the main pie, so a list that holds both the parent row and its parts counts that money twice.
The fix from Microsoft's own Q&A forum: leave the parent row out of the range and list its parts instead. Then set Split Series By to Value and type a threshold that catches only the parts (the thread uses 2000 in Values less than), so only the parts move to the second pie. Finally rename the combined slice's label from Others to the parent's name, such as Living Room.
In our view, pie of pie suits three to five small slices you still want named, and bar of pie suits more small slices, because a stacked bar gives each one a band of its own height instead of a sliver. If the small slices don't matter to your reader, merge them into a single Other slice on a plain pie, which is what most charts made here do: the median has five slices.
Practice what you learned with our interactive pie chart editor below. The chart is pre-filled with sample data to get you started.
Microsoft's own guidance is that a pie works best with no more than seven categories. Of the 20,428 charts downloaded from this site between January 29 and November 21, 2026, 3,329 (16.3%) had more than seven slices and 1,829 (9.0%) had ten or more. Those are the charts a pie of pie, a bar of pie or an Other slice is for.
Most charts are small, though: the median download had 5 slices and 78.5% had six or fewer. If your pie has five slices, a second pie only adds lines to read. Use pie of pie when the small slices are still worth naming one by one.
| More than seven slices | 16.3% | 3,329 of 20,428 downloads |
|---|---|---|
| Ten or more slices | 9.0% | 1,829 downloads |
| Six or fewer slices | 78.5% | 16,043 downloads |
| Median chart | 5 slices | half had fewer, half more |
Source: this site's own anonymous download log, January 29 to November 21, 2026, regenerated daily from the database by our data script (no chart contents are stored). Microsoft Support, Add a pie chart, read November 22, 2026, for the seven-category guidance.