Excel Donut Chart Percentage: Show and Calculate Labels

Charts & pivot tables · Updated November 19, 2026

To show percentages on an Excel donut chart, select the chart and choose Chart Design > Add Chart Element > Data Labels > More Data Label Options, then check Percentage in the Format Data Labels pane. Excel calculates each label as that slice’s value divided by the total of the values in its ring; it does not change the source data.

What a donut chart percentage means

A donut chart displays parts of a whole. For each category, Excel divides its plotted value by the sum of the plotted values in that series and displays the result as a percentage. For example, if a ring contains values of 42, 28, 18, and 12, the corresponding labels are 42%, 28%, 18%, and 12%, because the values total 100.

The percentages are calculated from the values used to draw the chart, not from the visible size of the hole or from a separate percentage column. The source values remain unchanged. Checking the Percentage option changes what the chart displays as a label; it does not convert the numbers in the worksheet into percentages.

A donut chart can contain more than one data series, shown as concentric rings. Excel calculates each ring’s percentages from that ring’s own values. A slice in the outer ring is therefore not necessarily a percentage of the inner ring or of all values across the chart. This matters when comparing rings: each one represents a separate whole unless your data and explanation establish otherwise.

Prepare the data before inserting the chart

Put category names in one column and the values to compare in the next. For instance, a monthly survey might have category names in A2:A5 and response counts in B2:B5: 42, 28, 18, and 12. Select the category and value cells, including their headings if present, then choose Insert > Insert Pie or Doughnut Chart > Doughnut. Keep the total row out of the selected range: charting the total as another category makes it part of the whole and gives misleading shares.

Use values that make sense as parts of one whole. Counts, amounts, and quantities are common choices, provided the categories are mutually exclusive and cover the intended group. If categories overlap, a donut can imply that they add up to a meaningful whole when they do not. A chart can still be drawn, but its percentages may communicate a false comparison.

  • Use one category label for each value and avoid blank rows in the selected range.
  • Check that all categories belong to the same total, such as responses to one question or sales by product for one period.
  • Do not include a grand total as a category alongside the values that make up that total.
  • Review zeros and missing entries. A zero has no visible slice; a blank may be treated differently depending on chart settings and the source range.

Show percentage labels in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, click the donut chart, then follow these steps:

  1. Open Chart Design > Add Chart Element > Data Labels > More Data Label Options.
  2. In the Format Data Labels pane, find Label Options and check Percentage.
  3. If you want only percentages, clear Value. Clear any other checked items, such as Category Name, if they make the labels crowded.
  4. Choose a label position, such as Best Fit or Outside End, if the available options suit the chart.

You can also select the chart and use the Chart Elements button (the plus sign) beside it to add Data Labels, then open the label options for the detailed settings. The pane is useful because it lets you choose which information appears, rather than simply turning labels on. On Excel for Mac, select the chart and use the Chart Design tab to add data labels; the wording or location of some controls can vary by release, but the Format Data Labels pane provides the Percentage option. Excel for the web has a more limited chart-editing interface than the desktop app, so use desktop Excel if you cannot find the label controls.

Format the labels and improve readability

Percentage labels can be accurate but hard to read if they overlap or show too many decimal places. In the Format Data Labels pane, adjust the label position and, where available, the Number settings to choose a percentage format and decimal places. Whole percentages are usually enough for a simple chart; a chart with several similarly sized slices may need one decimal place. Avoid adding precision that the underlying data does not support.

Displayed percentages can add up to 99% or 101% because each label is rounded separately. The underlying shares still total 100%. For example, three equal slices are each about 33.33%; if shown as whole numbers, the labels read 33%, 33%, and 33%, which totals 99%. Increasing decimal places can reduce this apparent discrepancy, but it does not change the data.

For a clean chart, show the percentage along with a category name only when there is enough room. Otherwise, use a legend or place the category name in the label and omit redundant information. A small donut with many categories is often clearer as a sorted bar chart, since thin slices and closely packed labels are difficult to distinguish.

Percentage labels versus worksheet percentage formulas

Use Excel’s built-in Percentage label when you want each slice’s share of its ring. You do not need to calculate percentages in the worksheet first. A worksheet formula is useful when you also need the shares in a table, want to audit them, or need to use them elsewhere.

With category values in B2:B5, enter this formula in C2 and fill it down through C5:

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

For the example values 42, 28, 18, and 12, the results are 42%, 28%, 18%, and 12% when the cells are formatted as percentages. The calculation is 42 divided by 100, 28 divided by 100, and so on. If you use these shares as the chart’s plotted values, the Percentage label option will calculate each share again relative to their total. That produces the same percentages in ordinary cases, but it is unnecessary; use the original values for the chart and the worksheet formula only where you need a separate percentage column.

If you need labels with specific text or a particular display, Excel can use worksheet cells as data labels. Select the chart’s labels, open Format Data Labels, and use Value From Cells if it is available in your desktop version. Select the cells containing the desired labels, then clear Percentage or Value if you do not want those shown too. This approach is helpful for custom wording, but the text then depends on the cell contents rather than being an automatically calculated chart percentage.

Common percentage-label problems

  • No Percentage checkbox: Confirm that you selected a data label, not the chart title, legend, or plot area. Open the Format Data Labels pane for the selected labels.
  • Labels show values instead: Check Percentage and, if you want only shares, clear Value. A value such as 42 is not the same display as 42%.
  • The percentages seem wrong: Check the chart’s selected data range. A total row, an unintended category, or extra values in the series change the denominator and therefore every share.
  • Labels do not add to 100%: Rounding is a common reason. Show more decimal places to make the displayed total closer to 100%.
  • Small slices have no readable labels: Move labels outside the ring, reduce the number of categories, or use a bar chart. Do not rely on color alone to identify many narrow slices.
  • A slice disappears: Check whether its source value is zero or blank. Also make sure the category and value ranges line up and that the intended value is actually included in the chart.

Negative values are not suitable for a part-to-whole donut chart: a negative amount cannot be represented as a meaningful positive share of the whole. If the data includes gains and losses, choose a chart designed to show values above and below zero, or separate the positive and negative figures and explain the comparison clearly.

When a donut chart is the right choice

A donut chart works best when there is one meaningful whole, a modest number of categories, and a reader needs to see approximate proportions rather than compare tiny differences precisely. The open center can hold a short total or summary, but it does not add information automatically. Avoid putting a second measure in the hole unless you can explain exactly how it relates to the ring.

A pie chart also shows parts of a whole, but its slices meet at the center; a donut chart leaves a blank center. Neither is ideal for precise comparisons between categories, because judging angles or arc lengths is harder than comparing bar lengths. Use a bar chart when exact ranking or small differences matter. Use a stacked chart only when it better suits the question and makes the shares easy to compare.

With multiple donut rings, be especially cautious. Excel calculates each ring as its own 100% total, and ring size or position does not establish a shared denominator. If your goal is to compare the same categories across years, a line or clustered column chart may communicate the changes more directly.

Frequently Asked Questions

How do I make an Excel donut chart show percentages?
Select the chart and choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In Format Data Labels, check Percentage; clear Value if you want percentages without the original numbers.

Does Excel calculate donut chart percentages automatically?
Yes. When Percentage is selected for data labels, Excel divides each plotted value by the total for that data series, or that ring if the chart has multiple series. The worksheet values are not changed.

Can I show both the value and the percentage?
Yes. In Format Data Labels, check both Value and Percentage. If the labels become crowded, show one of them and put the other information in the legend or worksheet instead.

Why do my donut chart percentages total 99%?
Each label is rounded for display, so the rounded values may total 99% or 101% even when the underlying shares total exactly 100%. Increase the displayed decimal places if the difference matters to readers.

Can a donut chart show percentages from multiple rings?
Yes, but Excel calculates each ring independently. Each ring represents its own 100% total, so do not compare a slice in one ring directly with a slice in another as though they shared a denominator.

Related

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.