Doughnut Chart in Excel: Create, Format, and Read It

Charts & pivot tables · Updated November 19, 2026

To make a doughnut chart in Excel for Microsoft 365 on Windows, select your category labels and values, then choose Insert > Insert Pie or Doughnut Chart > Doughnut. Excel creates a chart with a hole in the center; you can then add labels and adjust its appearance from the Chart Design tab and the Format Data Series pane.

Prepare data that suits a doughnut chart

A doughnut chart shows how categories contribute to one total. Put each category in one column and its numeric value in the next, with a clear heading above each column. For example, a small household budget table might list Rent, Food, Transport, and Other in A2:A5, with monthly amounts in B2:B5. Select both columns, including the category names and values, when you insert the chart.

For the chart to communicate clearly, use values that are meaningful parts of the same whole and cover the whole you want to describe. Categories should be mutually exclusive: if the same expense is counted under both Food and Other, the chart will not represent a valid breakdown. Values can be counts, quantities, or amounts; they do not have to be percentages. Excel calculates each slice as a share of the sum of the selected values.

  • Use one row per category and one value column for a simple chart.
  • Include a header row if you want Excel to use it as a series name or chart context.
  • Exclude grand-total rows from the selection. Including a total alongside its component categories counts the same amount twice.
  • Check that values are numeric rather than text, and decide how to handle blank cells or categories with zero values before charting.

A doughnut chart is not a good fit for negative values or a set of unrelated measurements. It is also less useful when there are many categories, because narrow slices become difficult to identify and compare.

Create the chart in Excel for Windows

  1. Select the category labels and their values. If the table has headers, include them too. You can select a rectangular range such as A1:B5.
  2. Open the Insert tab on the ribbon.
  3. In the Charts group, select Insert Pie or Doughnut Chart, then choose Doughnut.
  4. Excel inserts the chart on the worksheet. Drag its border to move it, or drag a corner handle to resize it.

If Excel places the categories in the legend incorrectly or creates an unexpected series, select the chart and open Chart Design > Select Data. In the Select Data Source dialog, inspect the chart data range and the entries under Legend Entries (Series) and Horizontal (Category) Axis Labels. You can use Switch Row/Column when the data orientation is reversed, or edit the range and labels directly. This is often faster than deleting the chart and starting again.

To make a chart from a table that is not contiguous, select the first range and then hold Ctrl while selecting the additional range on Windows. Nonadjacent selections can be inconvenient, and they must still form data Excel can interpret together; arranging labels and values in adjacent columns is usually simpler.

Format the chart and its doughnut hole

Click the chart to show the Chart Design tab. Use Add Chart Element to add or remove chart components, and use Chart Styles to apply a coordinated style. The chart title should explain what is being divided, such as Monthly spending by category, rather than simply repeating the chart type. If the legend and labels already identify every category, remove unnecessary elements to reduce clutter.

To change the size of the hole, right-click a doughnut slice and choose Format Data Series. In the Format Data Series pane, open Series Options and adjust Doughnut Hole Size. A larger hole leaves less room for the ring, so slices may look thinner; a smaller hole makes the ring wider. Choose a size that leaves the slices legible and does not make the chart feel crowded. The setting changes the appearance, not the underlying values.

You can change slice colors by selecting a slice and using the formatting controls on the ribbon, or by opening the Format Data Point pane. Be careful when applying a single fill color: formatting an individual data point differs from formatting the entire series. Use consistent colors for categories that readers need to recognize across several charts, and reserve strong contrast for the most important distinctions. Color alone should not carry essential meaning; labels provide a more reliable way to identify slices.

For more precise placement on the worksheet, use the chart’s sizing controls in the Format tab or adjust it by dragging. To use the chart in a report, keep enough space around its title, legend, and labels. Shrinking it too far can cause labels to overlap or disappear.

Add labels and explain what the slices mean

To add labels, select the chart and choose Chart Design > Add Chart Element > Data Labels, then pick a position such as Center, Inside End, or Outside End. The most useful position depends on slice size and chart dimensions. For more options, right-click a data label and choose Format Data Labels. In the pane, choose whether labels show the category name, value, percentage, or a combination. If labels collide, try a different position, enlarge the chart, or rely on a legend rather than forcing every label inside the ring.

Values and percentages answer different questions. A value tells readers the original amount, while a percentage communicates each category’s share of the total. For the budget example, a label might show a currency amount, a percentage, or both. If you show a percentage, check the underlying total and rounding: displayed percentages may not add to exactly 100% because each label is rounded. The slices are still calculated from the original values, not from the rounded labels.

The center hole is empty by default, but you can place a text box over it to display a useful summary, such as the total budget or month. On Windows, choose Insert > Text Box, draw the box over the chart’s hole, and type the text. Keep the text box visually associated with the chart, and make sure it does not obscure a slice or make the chart confusing. If the chart is moved, check whether the text box moves with it; grouping objects can help keep related elements together.

Understand multiple rings and what they compare

A doughnut chart can show multiple data series as concentric rings. For example, one series might show a department’s planned spending by category and another its actual spending. To create this arrangement, organize the data with category labels in the first column and one value column for each series, then select the complete table before inserting the chart. Excel uses a ring for each series.

Multiple rings can be compact, but they are not automatically an effective comparison. Readers must match slices across rings, and similarly sized slices can be hard to compare by eye, especially when the rings have many categories. A legend and data labels can help, but a clustered bar chart is often clearer when the main task is comparing exact values between groups. Consider a doughnut with several rings only when the shared categories and part-to-whole relationship are easy to understand.

When a doughnut chart is the right choice

Choose a doughnut chart when the main message is how a small number of categories make up one whole. The open center can create room for a total or a brief annotation, but it does not make the chart inherently more accurate than a pie chart. Both use slice angles or areas to represent shares, so readers can find close values difficult to compare.

  • Use a doughnut chart for a short, clear breakdown of a single total, such as responses by option or expenses by category.
  • Use a bar chart when readers need to compare category sizes precisely, rank many categories, or read long category names.
  • Use a line chart for change over time, where the order and trend between observations matter.
  • Use a 100% stacked bar chart to compare part-to-whole shares across several groups in a more directly aligned layout.

Do not assume the largest-looking slice is easy to interpret just because it is largest. Add a clear title and labels, and provide units when values are shown. If the values are percentages that do not total 100%, confirm whether that is expected. Excel still divides each value by the sum of the selected values, so the displayed share is relative to that selected sum rather than necessarily to an external target.

Common problems and how to fix them

  • The chart shows the wrong categories: Select the chart and open Chart Design > Select Data. Correct the category label range or use Switch Row/Column if Excel interpreted the table in the wrong direction.
  • A total appears as a huge slice: Remove any subtotal or grand-total row from the chart’s data range. A total should not be plotted beside the values that make up that total.
  • Labels are crowded or missing: Reduce the number of categories, enlarge the chart, move labels outside, or keep only the most useful label fields. A legend can identify small slices without placing text on top of them.
  • Small categories are hard to distinguish: Use a bar chart, group categories only when the grouping is meaningful, or show the exact values in a companion table. Avoid changing the data just to make the chart look more balanced.
  • The chart does not update as expected: Check whether the new rows fall inside the chart’s data range. If the source is an Excel table, adding rows directly below it generally expands the table; confirm the chart range if it still omits new data.

Remember that a doughnut chart normalizes the selected values into shares of their sum. If values include blanks, zeroes, or data that should not be part of the same total, correct the source selection rather than trying to solve the issue with color or labels.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, the chart workflow is broadly similar: select the data, use the Insert tab, and choose a doughnut chart from the pie or doughnut chart options. Ribbon wording and pane placement can vary slightly with the app version. For context menus, use a two-finger click or Control-click if your mouse does not have a right button. The Windows instructions above refer to the desktop app, not a specific Mac keyboard shortcut.

Excel for the web also supports creating charts, but available formatting options and the placement of controls can differ from the desktop application. If you cannot find a particular data-label or series-formatting control in the browser, open the workbook in the desktop version of Excel and make the change there. The chart remains part of the workbook and can be viewed in the browser afterward.

Frequently Asked Questions

How do I show percentages on an Excel doughnut chart?
Select the chart, then choose Chart Design > Add Chart Element > Data Labels and add labels. Right-click a label, choose Format Data Labels, and select Percentage. You can clear other label options if you want percentages without category names or values.

Can I put a total in the middle of a doughnut chart?
Yes. Insert a text box and position it over the hole, then type the total or a short explanation. The chart does not automatically calculate and place a center total; keep the displayed number consistent with the chart’s source data.

Can a doughnut chart show more than one data series?
Yes. Select a table with category labels and multiple value columns before inserting the chart. Excel uses each series as a separate ring. Use this only when the rings can be compared clearly; a bar chart may be easier for exact comparisons.

Why do my doughnut chart percentages not add up to 100%?
Excel calculates shares from the selected values, but labels are rounded for display. That rounding can make the visible percentages add to 99% or 101%. Also check whether the chart includes all intended categories and excludes totals or unrelated values.

How many categories should a doughnut chart have?
There is no fixed limit, but a chart is easiest to read with a small number of distinct categories. If slices become narrow, labels overlap, or readers cannot compare them, switch to a bar chart or provide a table alongside the graphic.

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.