Excel Donut Chart: How to Create, Format, and Use One

Charts & pivot tables · Updated November 19, 2026

An Excel donut chart displays how categories contribute to a whole, using colored segments arranged around a central hole. To create one in Microsoft Excel for Microsoft 365 on Windows, select category labels and their values, then choose Insert > Insert Pie or Doughnut Chart > Doughnut.

What a Donut Chart Shows

A donut chart, also called a doughnut chart, is a circular chart for showing part-to-whole relationships. Each slice represents a category, and the slice’s size reflects its value as a share of the series total. For example, if a team handled 100 service requests—45 by email, 25 by phone, 20 through chat, and 10 in person—the email slice represents 45% of the total.

The hole distinguishes a donut chart from a pie chart, but it does not automatically display a total or other figure. It is simply empty chart space unless you deliberately add a text box or another design element. Any text placed there should be kept in sync with the data; a manually typed total will not necessarily update when the source values change.

Donut charts work best when the categories are mutually exclusive, collectively describe the whole, and are few enough to distinguish. They are less useful when readers need to compare many similar values precisely: people generally judge lengths more accurately than angles or areas, so a bar chart may communicate small differences better.

Prepare the Source Data

Arrange the data in a simple table, with one category column and one column of numeric values. Include a descriptive heading above each column. For example, cells A1:B5 could contain Category and Requests as the headings, followed by Email—45, Phone—25, Chat—20, and In person—10. Select the headings and all four rows when you insert the chart.

Check the source before charting. Values should be numeric and should describe the same whole and reporting period. If the categories omit a meaningful portion of the total, readers may mistake the displayed slices for the complete picture. Either include an Other category or explain the omission in the chart title or nearby text. Avoid negative values: a negative number cannot be meaningfully represented as a positive share of a circular whole. Zero values have no visible slice.

For a clear chart, use category names that are short enough to fit in labels or a legend. Sort the source values in a deliberate order, such as largest to smallest, if that makes the comparison easier. Excel uses the source category order for the slices; sorting the table can therefore change how the chart reads. If you need to preserve a particular sequence, such as months or steps in a process, keep that sequence instead of sorting by value.

Create a Donut Chart in Excel

  1. Select the category labels and values, including their column headings. If the columns are not adjacent, select the first range, then hold Ctrl on Windows while selecting the other range.
  2. Choose Insert > Insert Pie or Doughnut Chart, then select Doughnut. Excel inserts the chart on the worksheet.
  3. Use the chart title to state what the numbers represent. Replace the default title with a specific description, such as Service requests by channel, rather than a vague label such as Results.
  4. Review the chart’s category order, colors, labels, and legend. Resize the chart if the text is crowded, and check that all slices correspond to the intended source data.

To change an existing chart, select it and use Chart Design > Change Chart Type, then choose Doughnut under the pie and doughnut chart options. In Excel for Mac, the same general chart choices are available on the ribbon, although the arrangement and appearance of controls can differ. Excel for the web also offers chart insertion and basic formatting, but some detailed controls may be arranged differently or may not match the desktop interface.

Format the Hole, Slices, and Colors

To adjust the hole, right-click a slice and choose Format Data Series. In the Format Data Series pane, use the Doughnut Hole Size control to make the hole larger or smaller. A larger hole can create room for a central label, but it also makes the colored ring thinner. A smaller hole gives the slices more visual area. Choose a size that leaves both the chart and any labels easy to read.

The same pane includes Angle of first slice, which rotates the chart and changes where the first category begins. Rotation can help put an important slice in a convenient position or keep labels from colliding. It does not change the values. Use rotation consistently if readers will compare several charts side by side; otherwise, the same category may appear in different positions in each chart.

To change the chart’s color palette, select it and choose Chart Design > Change Colors. Use distinct colors that remain easy to tell apart, and do not rely on color alone to identify categories. Labels or a legend provide another way to interpret the chart, including for readers who have difficulty distinguishing some colors. If you manually recolor individual slices, keep the category-to-color mapping consistent across related charts.

Formatting is most effective when it supports the data rather than decorating it. Avoid strong 3-D effects, excessive outlines, and gradients that make slice sizes harder to judge. A plain two-dimensional chart with a concise title and a restrained palette is usually easier to compare.

Add and Choose Data Labels

Labels can show category names, values, percentages, or combinations of those details. To add them, select the chart and choose Chart Design > Add Chart Element > Data Labels, then select a position. For more control, choose More Data Label Options. In the formatting pane, select the label information you want and clear options you do not need.

For the 45, 25, 20, and 10 example, the total is 100, so percentage labels are 45%, 25%, 20%, and 10%. If the values instead were 45, 25, 20, and 10 thousand requests, their shares would still be those percentages, provided they describe the same complete total. A chart can show values and percentages together, but doing so may clutter the slices. For four categories, category names plus percentages may be enough; a legend can identify categories when labels do not fit.

Check percentage precision. Whole percentages are easy to scan when the values are not extremely close; decimal places may be useful for small differences but can imply more precision than the source warrants. If a label overlaps another slice or sits outside the chart awkwardly, try a different label position, enlarge the chart, shorten category names, or move the legend. Do not remove a category merely to make the labels fit if that would misrepresent the data.

Using More Than One Ring

A doughnut chart can display multiple data series as concentric rings. For example, a retailer might use one ring for this year’s sales mix and another for last year’s mix, with the same product categories in each series. Each ring represents its own series, and its slices show the categories’ shares within that series. That makes a donut chart suitable for a broad visual comparison of composition across two periods.

Multiple rings can become difficult to read, especially when the chart has many categories or the values change substantially between series. The reader must match colors across rings and judge slice sizes at different distances from the center. Keep the category order and colors consistent, explain which period belongs to each ring, and avoid adding rings simply because Excel allows more than one series. If precise comparisons between periods matter, a clustered bar chart or a table may be clearer.

When adding series, make sure the category labels align correctly across the source table. A missing or misaligned category can make rings appear to compare unlike items. Also remember that a ring’s slice sizes show shares of that ring’s own total, not a common scale of raw values across all rings. A slice that looks similar in two rings can represent different numbers if the series totals differ.

When to Use a Donut Chart—and When Not To

Use a donut chart when the central question is how a small set of categories divides a whole. Examples include a household’s monthly spending by category, a survey’s distribution of responses, or a project’s share of completed tasks by status. It is especially useful when the audience needs a quick sense of the largest categories rather than exact ranking among close values.

Choose another chart when the data do not form a meaningful whole, when there are many categories, or when the goal is to compare values over time. A line chart is generally more appropriate for a time trend. A bar chart is often preferable for ranking categories or comparing close amounts. A stacked bar chart can show part-to-whole composition while making it easier to compare segment lengths across groups.

A common misconception is that every percentage chart must add up to 100%. A donut chart displays each category as a share of the values supplied for its series; it cannot tell whether the source table includes every relevant category. Check the data and the question being answered before interpreting the slices as a complete distribution.

Common Problems and Fixes

  • The chart includes the wrong labels or values: Select the chart and use Chart Design > Select Data to review the chart’s data range and series. Confirm that the category labels and numeric values are paired row by row.
  • Small slices are hard to see: Add percentage labels, enlarge the chart, or group genuinely minor categories into Other when doing so is honest and useful. If the small values need close comparison, use a bar chart instead.
  • Percentages do not match expectations: Check whether the source includes all intended categories and whether the series contains unintended rows, such as a total row. Including a total as another category counts it as an additional slice and distorts the shares.
  • The chart looks crowded: Reduce the number of displayed label fields, shorten category names, or use a legend. Avoid forcing long labels onto small slices.
  • The colors or order change after editing: Review the source row order and chart formatting. Sorting the source can reorder slices, while changing the palette can change category colors. Recheck charts that readers compare with earlier versions.

Frequently Asked Questions

How do I add a total in the middle of an Excel donut chart?
Excel does not automatically place a total in the hole. You can insert a text box and position it over the center, but a manually entered number will not update with the chart data. If the total changes, update the text as well or use a linked approach appropriate to your workbook.

Can an Excel donut chart show percentages?
Yes. Add data labels, open More Data Label Options, and select Percentage. You can show percentages alongside category names or values, but displaying every field can make a chart crowded.

Can a donut chart show negative numbers?
It is not an appropriate chart for negative values because slices represent positive shares of a whole. Use a bar chart or another chart type that can show values on both sides of zero.

Why does my donut chart have a slice for the total?
The selected range probably includes a total row as though it were another category. Edit the chart’s data range so it includes the individual categories but not a separately calculated grand total.

What is the difference between a pie chart and a donut chart?
Both show parts of a whole as slices. A donut chart has a hole in the center, which can make room for a label or simply create a different visual style. Neither is automatically better for precise comparisons; the right choice depends on the number of categories and what readers need to see.

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.