Excel Tutorial

How to Make a Pie of Pie Chart in Excel

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

The short answer

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.

Follow These Steps

1

Put labels and numbers in two columns

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.

2

Click Insert > Insert Pie or Doughnut Chart > Pie of Pie

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.

3

Check what Excel moved

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.

4

Set Split Series By

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.

5

Size the second pie and the gap

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.

6

Add labels and rename the combined slice

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.

7

Fix percentages that don't add to 100

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

The Format Data Series settings for a pie of pie chart

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.

SettingWhat it doesWhat to enter
Split Series By: PositionMoves the number of values you enter into the second pieValues in second plot: how many, such as 3 if you want the 3 smallest (Microsoft's own example)
Split Series By: ValueMoves every value below a number you pickValues less than: a number in your data's units, such as 2000
Split Series By: Percent valueMoves every slice below a share of the totalValues less than: a percentage, such as 5% to catch slices of 3%, 3% and 4%
Moving one slice by handMicrosoft'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 sizeSize of the second pie as a percentage of the main pie (the SecondPlotSize property)5 to 200
Gap widthSpace 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.

Showing one category's breakdown (pie of pie with subcategories)

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.

Pie of pie, bar of pie, or one Other slice?

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.

Try It Yourself

Practice what you learned with our interactive pie chart editor below. The chart is pre-filled with sample data to get you started.

Enter Your Data

Edit the sample data or add your own

Label
Value
%
Live preview active
Total: 100

Chart Preview

Export to PNG, SVG, PDF

Made with pie-chart-generator.com
My Pie Chart Data
CategoryValuePercentage
Category A3030.0%
Category B2525.0%
Category C2020.0%
Category D1515.0%
Category E1010.0%

Categories

5

Total Value

100

Chart Type

pie

Chart Settings

0°

Export Chart

Slide-ready HD export without watermark

Drop clean 2,712 px PNG or vector SVG straight onto dark or colored slides.

Standard free download (1,356 px)Includes small credit line

No account required. Instant activation in this browser.

Tips & Best Practices
  • Sort the data largest to smallest before splitting by Position, so the moved rows are the smallest.
  • Split by Percent value when the data will change; a 5% threshold keeps working as numbers move.
  • Give the combined slice a real name instead of Other.
  • Keep three to five slices in the second pie; past that, Bar of Pie reads better.
  • Turn on percentages and check that they total 100 before you paste the chart into a report.

How often a pie is crowded enough to need a second pie

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 slices16.3%3,329 of 20,428 downloads
Ten or more slices9.0%1,829 downloads
Six or fewer slices78.5%16,043 downloads
Median chart5 sliceshalf 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.

Sources

Frequently Asked Questions