Last updated on November 5th, 2026 at 02:57 pm
Have a column of amounts, or a pie showing raw numbers, and want each slice to show its share? Excel works out the percentages itself. With the chart selected, open Chart Design > Add Chart Element > Data Labels > More Data Label Options, check Percentage and clear Value. A raw list with repeated entries, or labels that must total exactly 100%, needs a different route.
Applies to: current Microsoft 365 Excel, plus the 2024 and 2021 versions, on Windows and Mac.
How Excel works out each slice’s percentage
A pie chart plots one series of numbers. Excel adds up every value in the chart range and divides each slice by that total, so the percentage label is always “this slice as a share of everything plotted.” You never need to type a percentage or write a formula for it.
That has two consequences. If a Total row sits inside the range, Excel treats it as one more slice and every other percentage halves. And if you change, hide or filter a value, the other percentages shift to match the new total. Microsoft’s pie chart page also recommends one series, no zero or negative values, and no more than seven categories.
Choose the labeling route that fits your data
| Your situation | Best route | Why |
|---|---|---|
| A short table of categories and amounts | Format Data Labels with Percentage checked | Full control over what each label shows and where |
| You want a percentage on every slice in one click | Chart Design > Quick Layout, picking a layout that shows percentages | Fast, but it may also change the title and legend |
| Labels must add to exactly 100%, or use a total other than the chart’s | A helper column plus Values From Cells | The labels show your calculated numbers |
| A long list where items repeat (one row per sale or survey answer) | A PivotChart | Excel counts or sums each category first |
Worked example: label a household budget pie
Priya wants to see where her $2,000 of March spending went. The amounts come from the Actual column she uses to make a monthly budget in Excel.
| Expense (column A) | Amount (column B) |
|---|---|
| Rent | 1,250 |
| Food | 475 |
| Transport | 175 |
| Utilities | 100 |
- Sort the amounts largest to smallest (Data > Sort) so the slices run in size order around the pie.
- Select A1:B5, including the headers but not any Total row.
- On the Insert tab, select Insert Pie or Doughnut Chart and choose Pie under 2-D Pie.
- With the chart selected, go to Chart Design > Add Chart Element > Data Labels > More Data Label Options. You can also use the plus (+) button beside the chart, where the same command is called More Options, or right-click a slice and choose Format Data Labels.
- In the pane, under Label Options > Label Contains, check Percentage and clear Value. Check Category Name too if you want “Rent” printed on the slice.
- Want the dollar amount as well? Leave Value checked and set Separator to (New Line), so a label reads 1,250 above 63%.
- Under Label Position, pick Best Fit or Outside End. Outside labels get leader lines when they move away from their slice.
Priya’s labels now read 63%, 24%, 9% and 5%. If you keep a legend instead of category names on the slices, you can tidy its wording by editing the legend in Excel. Colors, titles and fonts are covered in editing a graph in Excel. Microsoft’s data labels page lists every label option.
When the labels don’t add up to 100%
Add Priya’s labels: 63 + 24 + 9 + 5 = 101%. Nothing is wrong with the chart. The true shares are 62.5%, 23.75%, 8.75% and 5%, and Excel rounds each label on its own. You have three choices:
- Show a decimal place. In Format Data Labels, expand Number, set Category to Percentage and Decimal places to 1. This also stops small slices all reading 0% or 1%. It doesn’t always fix the total: Priya’s labels become 62.5, 23.8, 8.8 and 5.0, which still adds to 100.1%.
- Add a note. For many reports, a line such as “Percentages may not total 100 because of rounding” is the honest answer.
- Use a helper column when the total must read exactly 100%, described next.
For the helper column, type =ROUND(B3/SUM($B$2:$B$5),2) in C3 and fill it down to C5. In C2, next to the largest slice, type =1-SUM(C3:C5) so that slice absorbs the rounding. Format column C as Percentage with no decimals. Then in Format Data Labels, check Values From Cells, select C2:C5 in the Data Label Range box, select OK, and clear Percentage. The labels read 62%, 24%, 9% and 5%, and they still update when the amounts change. Formulas like these are explained further in multiplying by a percentage in Excel.
The same helper column works when you need a share of something other than the chart total, such as a share of a target. If your percentages arrived as text or need turning back into amounts, see converting a percentage to a number in Excel.
Starting from a raw list: let a PivotChart count it
Suppose Alex has 300 survey rows, each with one answer such as “Email”, “Phone” or “Chat”. A pie made straight from that column would be a mess. Let Excel group the answers first:
- Click inside the list and press Ctrl + T to make it an Excel table, so new rows are included later.
- Go to Insert > PivotChart and place it on a new worksheet.
- Drag the answer field to Axis (Categories) and drag it again to Values, where it shows as a count.
- Change the chart to a pie with Change Chart Type, then add Percentage labels as in the worked example.
- After adding rows, right-click the PivotTable and select Refresh (or use Refresh on the PivotTable Analyze tab) so the chart picks them up.
If PivotTables are new to you, making a pivot table in Excel covers the field list.
Make small slices readable
- Combine tiny items into an “Other” row so you stay near Microsoft’s seven-category guidance.
- Use Pie of Pie or Bar of Pie (Chart Design > Change Chart Type) to pull the smallest slices into a second chart.
- Try Data Callout in the Data Labels menu, which puts each label in a bubble that is easier to place.
- Rotate the pie: right-click a slice, select Format Data Series, and change Angle of first slice so small slices and their labels land where there is room.
- Pull one slice out to draw the eye, as shown in exploding a slice of a pie chart in Excel.
- Switch to a bar chart if readers must compare slices that are close in size. Avoid 3-D pies, which distort slice size.
What differs by version
- Excel for Mac: the same Insert and Chart Design tabs and Format Data Labels options, opened in a side pane.
- Excel 2019 and 2016: the Chart Design tab is labeled Design.
- Quick Analysis: on Windows, selecting data and pressing Ctrl + Q opens Quick Analysis, whose Charts tab often includes a pie. Excel for Mac doesn’t have Quick Analysis.
To place the finished chart in a report, copying a graph from Excel to Word explains the linked and picture options.
Questions about percentage labels that don’t look right
Why does one slice take up half the pie?
A Total row is almost certainly in the chart range. Go to Chart Design > Select Data and narrow the range so it stops above the total.
Why is a slice missing or showing 0%?
Zero values have no slice, and pie charts can’t show negative values. Numbers stored as text are also ignored, so check for a green triangle in the cell or left-aligned numbers.
Will the percentages change if I filter or hide rows?
Yes. By default, charts skip hidden rows, so the remaining slices are recalculated against a smaller total. To keep hidden rows in the chart, go to Select Data > Hidden and Empty Cells and check Show data in hidden rows and columns.
Can I show a percentage on just one slice?
Yes. Add labels to all slices, click any label once to select them all, then click the one you want to remove again so it is selected on its own, and press Delete. Repeat for each label you don’t need.
Do the labels update when the numbers change?
Yes, both built-in Percentage labels and helper-column labels recalculate as soon as an amount changes. New rows added below the range are only picked up if the data is an Excel table or you widen the range in Select Data.
Next step: once the percentages read correctly, give the chart a title that states the total, such as “March spending, $2,000,” so readers know what 100% stands for.

Matt Jacobs writes and maintains the guides on Support Your Tech, which he started in 2017. He spent most of his career keeping small-business PCs running and still takes the occasional consulting job, so the steps here come from fixing the same problems on other people’s computers. Every guide is checked on his own Windows 11, Windows 10, Mac, iPhone and iPad before it goes up.