Yes. In Microsoft Excel for Microsoft 365 on Windows, select your category names and values, choose Insert > Insert Pie or Doughnut Chart > Doughnut, then use Chart Design > Add Chart Element > Data Labels > More Data Label Options and select Percentage. Excel calculates each slice as a share of the values plotted in the chart; it does not simply copy a percentage format from your worksheet.
What a doughnut chart shows
A doughnut chart is a circular chart with a blank center. Its slices represent parts of a whole, so it is useful for showing how a total is divided among a small number of categories: for example, a department’s budget, survey responses, or sales by product. A percentage label tells readers what share of the chart’s total belongs to each slice.
The chart’s percentages are calculated from the values it receives. If the plotted values are 45, 30, 15, and 10, their total is 100, so the slices represent 45%, 30%, 15%, and 10%. If the values instead are 18, 12, and 10, their total is 40, and the corresponding shares are 45%, 30%, and 25%. The worksheet values do not have to add up to 100 for Excel to show percentage labels.
This distinction matters when the data are already percentages. If you chart values of 20%, 30%, and 50%, their shares of the plotted total are 20%, 30%, and 50%. But values of 20%, 30%, and 60% total 110%, so Excel displays their relative shares of 110%, not the original entries as a set totaling 100%.
Prepare data that makes sense as a whole
Arrange the data in two columns: one for category names and one for numeric values. Keep the labels beside the values so Excel can use them as slice names. A simple table might contain Product A, 45; Product B, 30; Product C, 15; and Product D, 10. Select the heading and data cells together if you want Excel to use the headings when identifying the chart’s series.
Before charting, check that the categories are mutually exclusive and that the values measure the same thing over the same period. A doughnut chart can look polished even when the data do not form a meaningful whole, so a clear denominator is essential. For example, sales by product for one month can describe a whole if every sale is assigned to exactly one product. A list of monthly sales totals for several months is usually a trend over time, not a breakdown of one whole.
- Use one concise category name for each value.
- Include only the categories you intend viewers to compare.
- Check that the values are numeric and represent comparable quantities.
- Avoid negative values: a doughnut chart cannot communicate negative shares meaningfully.
Create the doughnut chart in Excel
- Select the category labels and the corresponding values, including headers if present.
- On the ribbon, choose Insert > Insert Pie or Doughnut Chart.
- Choose Doughnut from the chart options.
- Select the new chart to show its chart tabs, then choose Chart Design > Add Chart Element > Data Labels > More Data Label Options.
- In the Format Data Labels pane, under Label Options, select Percentage. Clear Value if you want the labels to show percentages without the underlying numbers.
If you prefer to start with a chart and add labels afterward, select the chart and follow the same Chart Design path. You can also right-click a data label and choose Format Data Labels to open its formatting pane. In Excel for Mac, the ribbon tabs and chart commands are broadly similar, although their location or presentation can differ by release. In Excel for the web, chart options may be arranged differently and some detailed formatting controls can be more limited than in the desktop app.
Choose what each label displays
Percentage is only one possible label component. The Format Data Labels pane can also offer options such as Category Name and Value. Combining a category name with a percentage is often helpful when there are only a few slices and enough room around the chart. For example, a label might identify Product A and show 45%. Showing every available item can make labels crowded, especially with many narrow slices.
To show only percentages, select Percentage and clear Value and any other label components you do not need. If you want to show the category alongside the percentage, select Category Name as well. You can reposition labels by choosing a label position in the pane, such as Center, Inside End, or Outside End, where those options are available. The best choice depends on the chart size and the number of slices; check that labels do not overlap or become detached from the slices they describe.
To control the number of decimal places, select a label and inspect the Number options in the Format Data Labels pane. Choose a percentage number format and set the decimal places to suit the data. Whole-number labels are usually easier to scan, while decimal places can help when categories have similar shares. Rounding means displayed labels may add to 99% or 101% even when the underlying shares total 100%; that is a display effect, not necessarily an error in the source values.
Customize the ring and improve readability
A doughnut chart’s center hole is adjustable. Right-click a slice and choose Format Data Series, then use Series Options to change Doughnut Hole Size. A larger hole leaves less room for the slices, while a smaller hole makes the ring thicker. The center can be left blank or used for a short total or key figure, but avoid adding text that competes with the slice labels.
Use color to distinguish categories, not to suggest unsupported meaning. Keep category colors consistent if the same categories appear in related charts, and avoid relying on color alone to identify a slice. Direct labels can help readers who may not distinguish colors easily. If the chart has many tiny categories, consider grouping minor categories only when that grouping is analytically appropriate; do not combine unrelated items merely to make the chart look simpler.
A chart title should state what the whole represents and, where useful, the period. For instance, Budget allocation, 2026 is more informative than Percentage. To add a title, select the chart and use Chart Design > Add Chart Element > Chart Title. If the chart is for a report, make sure the source, time period, and unit are clear nearby, particularly if the values could be mistaken for counts, dollars, or percentages from a different base.
How Excel calculates the percentage
For each slice, Excel divides that category’s value by the sum of the plotted values and displays the result as a percentage. With values 45, 30, 15, and 10, the total is 100: 45 divided by 100 is 45%, 30 divided by 100 is 30%, 15 divided by 100 is 15%, and 10 divided by 100 is 10%. This calculation happens in the chart; you do not need to add a percentage column to create percentage labels.
The chart’s selection determines the denominator. If a source table contains five categories but you chart only four, Excel calculates each displayed share from those four plotted values. The omitted category is not silently included in the chart total. Likewise, filtering or changing the chart’s source can change the displayed shares. When the audience needs to know the exact denominator, make the scope explicit in a title, subtitle, note, or accompanying table.
When you edit a plotted value, Excel updates the slice and its percentage label. If you need the percentages as worksheet data for another calculation, create a separate percentage column rather than trying to copy labels out of the chart. That column can be formatted as Percentage and will make the calculation visible and reusable in the workbook.
Common problems and what to check
- The percentage option is missing: Confirm that the chart type is Doughnut or Pie and that you selected a data label, not the chart area or a legend item. Open Format Data Labels and look under Label Options.
- The labels show numbers instead of percentages: Select Percentage and clear Value if you want percentages alone. Value displays the source amount, which is a different label component.
- The percentages do not match the worksheet’s percentage column: Excel is calculating each value’s share of the chart total. Check whether the plotted values total 100 and whether every intended category is included.
- The labels do not add up to exactly 100%: Rounding can cause a small difference. Increase decimal places to inspect the displayed shares, and check the source values if the difference is substantial.
- The chart looks difficult to read: Reduce the number of categories, enlarge the chart, move labels outside, or use a bar chart. Too many thin slices are hard to compare and label.
Also check for blank cells, text in the value column, duplicated categories, and accidental inclusion of a total row. Including a total row as if it were another category changes the denominator and produces misleading shares. A grand total generally should not be plotted alongside the individual categories that make up that total.
Doughnut chart versus pie chart and alternatives
Pie and doughnut charts both show parts of a whole, and both can display percentage data labels. A pie chart fills the center; a doughnut chart leaves a hole that can provide visual breathing room or space for a central figure. Neither chart is ideal for precise comparisons between similarly sized slices because viewers must judge angles or arc lengths. A sorted bar chart is often clearer when comparing many categories or small differences.
A doughnut chart can display more than one data series as concentric rings. Each ring represents a separate series, and percentages are calculated within that series rather than as shares of every value across all rings. This can be useful for a small number of related breakdowns, but comparing slice sizes across rings is less straightforward. For a simple percentage breakdown, one ring is usually easier to interpret.
Choose a different chart when the underlying question is different. Use a line chart to show change over time, a bar or column chart to compare category values, and a stacked bar chart when you need to compare composition across groups. A doughnut chart is most effective when there is one meaningful whole and a modest number of categories.
Frequently Asked Questions
How do I show percentages on a doughnut chart in Excel?
Select the chart, then choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In Format Data Labels, select Percentage. Clear Value if you do not want the source numbers shown too.
Can I show both the category name and percentage?
Yes. In the Format Data Labels pane, select Category Name and Percentage. If the labels become crowded, use a larger chart, move labels outside where available, or show fewer categories.
Why do my doughnut chart percentages not total 100%?
They may be rounded for display, so the visible labels can total 99% or 101%. If the gap is larger, check for an included total row, omitted categories, an unintended selection, or values that do not represent the whole you mean to chart.
Can Excel calculate percentages if my values are not percentages?
Yes. Excel divides each plotted value by the total of the plotted values. For example, values of 40, 35, and 25 produce percentage labels of 40%, 35%, and 25% because they total 100; values of 4, 3, and 1 produce 50%, 37.5%, and 12.5%.
Can I put a total in the center of a doughnut chart?
Yes. You can add a text box or another suitable chart element over the hole, then enter a short total or headline figure. Keep it readable and ensure it refers to the same categories and period as the ring.
Is a doughnut chart better than a pie chart for percentages?
Not automatically. Both can show percentages. A doughnut chart offers a center space and a different visual style, while a pie chart uses a filled circle. For many categories or precise comparisons, a bar chart is generally easier to read.
Related
- Comparison Spreadsheet Template Excel: Setup and Examples
- Comparison Table Excel Template: Build, Format, and Use
- Comparison Excel Sheet Template: Build a Clear Side-by-Side
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Easy Org Chart in Excel: Steps and TipsYes. The easiest way to make an org chart in Excel for Microsoft 365 on Windows is to…
- Excel Double Stacked Column Chart: How to Build OneExcel does not have a chart type called a double stacked column chart, but you can create the…
- Excel Pivot Table Value Filter Not Working? FixesIf an Excel PivotTable value filter is not working, first confirm you applied it to a row or…
- Can You Create a Bubble Chart in Excel? Steps and TipsYes. In Excel for Microsoft 365 on Windows, arrange your data in columns for X values, Y values,…
- Excel Chart Overlay: How to Plot Two Data Sets TogetherYes. In Excel for Microsoft 365 on Windows, you can overlay two data sets by adding both as…
- Excel HR Dashboard Template: Metrics, Setup & TipsAn Excel HR dashboard template is a workbook that turns organized employee and workforce data into a concise…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.