Excel Pie Chart Percentages: Show and Calculate Them

To show percentages on an Excel pie chart, select the chart, then choose Chart Design > Add Chart Element > Data Labels > More Data Label Options and check Percentage in the Format Data Labels pane. Excel calculates each slice as its value divided by the total of the values plotted in the pie; you do not have to add percentage formulas to display the labels.

What a pie chart percentage means

A pie chart represents a whole as slices. Excel calculates a slice’s percentage using the value for that category divided by the sum of the values in the chart’s series. For example, if four categories have values of 40, 30, 20, and 10, the total is 100 and their shares are 40%, 30%, 20%, and 10%.

The percentage label is therefore a share of the chart’s plotted total, not necessarily a percentage already stored in the worksheet. If your source numbers are 4, 3, 2, and 1, the chart still shows the same shares as it would for 40, 30, 20, and 10. Changing the scale of every value by the same factor does not change the slices.

This distinction matters when the selected range contains the wrong rows. Excel uses the data included in the chart, so adding a grand-total row as if it were another category changes the denominator and makes every slice smaller. Include the category values, but normally leave out a separate total row.

Create a pie chart and display percentages

For a basic chart in Excel for Microsoft 365 on Windows, arrange category names in one column and their numeric values in the next. Select those cells, including the headings if present, and choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. A pie chart is most useful when the values describe parts of one whole.

Select the chart so the chart-specific ribbon tabs appear.
Choose Chart Design > Add Chart Element > Data Labels, then select a label position such as Outside End or Best Fit. You can also choose More Data Label Options to open the formatting pane.
In Format Data Labels, under Label Options, check Percentage. Uncheck Value if you want percentages without the underlying numbers.
To identify each slice, also check Category Name. If the chart already has a clear legend and the labels would be crowded, you may prefer to show percentages alone.

Excel may add labels with a default combination of category, value, or percentage depending on how the chart was created. Use the checkboxes in the formatting pane to control what appears; selecting Percentage does not require deleting and recreating the chart. Click away from the chart when you finish to see the labels in the worksheet.

Choose useful labels and formatting

Percentage labels are easiest to read when each slice is large enough to hold its text and the chart has a modest number of categories. For a small chart, placing labels outside the slices can reduce overlap. For a presentation, category names beside percentages can make the legend unnecessary, but long names may clutter the chart. Try one layout, then adjust the label position or chart size if labels collide.

To change how many decimal places appear, select a data label and open Format Data Labels. In the Number section, choose Percentage and set the desired decimal places. The displayed precision changes, not the underlying values or the slice proportions. A whole-number label is often readable, but values rounded individually may not add to exactly 100%.

Use color and emphasis sparingly. A contrasting color can call attention to one slice, but a pie chart should still make the relative sizes apparent. If you explode or pull out a slice, make sure the visual effect does not imply a different value. Avoid using 3-D effects for comparisons: perspective can make slices look larger or smaller than their actual shares.

Calculate percentages in worksheet cells

You may want worksheet percentages as well as chart labels—for example, to make a table, check rounding, or use the shares in another calculation. With category names in A2:A5 and values in B2:B5, enter this formula in C2 and fill it down through C5:

=B2/SUM($B$2:$B$5)

For values 40, 30, 20, and 10, the results are 40%, 30%, 20%, and 10%. Format C2:C5 as Percentage using Home > Number > Percent Style, or press Ctrl+Shift+% on Windows. The formula returns a decimal share—for example, 0.4—and percentage formatting displays that value as 40%.

The dollar signs keep the total range fixed when you copy the formula down. The numerator changes from B2 to B3, B4, and B5. If your data range grows, update the total range or use an Excel Table so formulas and chart source data can be extended more easily.

If you chart the calculated percentages, Excel will calculate each percentage again as a share of the percentages’ total. When the original categories add to 100%, the displayed shares stay the same apart from rounding. For most cases, charting the original values is simpler; use the worksheet formula when you need the percentage as a cell result.

Rounding and totals that do not equal 100%

Displayed percentages can add to 99% or 101% when Excel rounds each label separately. For example, three equal slices are each about 33.333%; with zero decimal places, the labels show 33%, 33%, and 33%, totaling 99%. The chart’s slice sizes still represent the full whole. Increasing the number of decimal places can make the displayed sum closer to 100%, though rounded labels are not a substitute for the exact values.

If the chart’s shares seem unexpectedly different, check which values are included and whether the data has been filtered. Confirm that the selected series contains the intended categories and excludes totals, subtotals, and unrelated rows. Also check for values stored as text, blank cells, or zeros. A pie chart cannot give a meaningful share for an all-zero series, because its total is zero.

Negative values do not represent parts of a positive whole in the usual pie-chart sense. Clean or separate the data before charting rather than interpreting a negative slice as a normal percentage. If some values are missing or not applicable, decide whether they should be excluded or represented another way; do not silently treat missing data as a zero if that would change the story.

When a pie chart is the wrong choice

A pie chart works best when there is one series, a clear whole, and a limited number of nonnegative categories. It becomes difficult to compare slices with similar sizes, and many tiny categories are hard to identify. Grouping several small categories as “Other” can help if that grouping is meaningful and the underlying values remain available to readers.

For precise comparisons across many categories, a bar or column chart is usually easier to read because people can compare lengths against a common scale. A 100% stacked bar chart can be useful for comparing how several groups divide into parts, while a regular pie chart is intended to show one group’s composition. Choose the chart based on the question: “What share of this whole?” suits a pie; “Which category is larger?” often suits a bar chart.

Excel on Mac and Excel for the web

The instructions above use Excel for Microsoft 365 on Windows. In Excel for Mac, select the chart and use the Chart Design tab’s Add Chart Element and Data Labels controls; the ribbon layout can differ slightly by release. The Format Data Labels pane contains the Percentage option when that label setting is available.

Excel for the web supports creating and editing charts, but its ribbon and formatting controls can be more limited or arranged differently from desktop Excel. Select the chart and look for the chart-specific controls for data labels. If you cannot find label-position or number-format options, open the workbook in the desktop app to use the full formatting pane. Menu names and available features may change as Microsoft updates the web app.

Frequently Asked Questions

How do I show percentages instead of values on an Excel pie chart?
Select the chart, open Chart Design > Add Chart Element > Data Labels > More Data Label Options, then check Percentage and clear Value in Format Data Labels.

Why do my pie chart percentages not add up to 100%?
Excel rounds each displayed label independently. The underlying slice proportions still make up the whole; show more decimal places if you need the visible labels to total closer to 100%.

Does Excel calculate pie chart percentages automatically?
Yes. When you turn on the Percentage data-label option, Excel calculates each slice’s share from the plotted values. A separate worksheet formula is optional.

Can I show both the category name and percentage?
Yes. In Format Data Labels, select both Category Name and Percentage. If the labels overlap, move them outside the slices, enlarge the chart, or use a legend.

Why are my percentages different after I add data?
The added values may have changed the total used as the denominator, or the chart may now include an unintended row such as a total. Check the chart’s selected data range and its categories.

Can a pie chart show negative values?
A pie chart is meant to show nonnegative parts of a whole. Negative numbers do not have a meaningful ordinary slice share, so use a different chart or prepare a suitable positive dataset.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.