Excel Donut Chart With Multiple Rings: Setup and Tips

Charts & pivot tables · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, a doughnut chart can show multiple rings when its source data contains multiple data series: each series becomes a ring, and the categories in that series become its slices. Arrange categories in rows and series in columns, select the table, then choose Insert > Insert Pie or Doughnut Chart > Doughnut.

What a multiple-ring doughnut chart shows

A doughnut chart is a pie chart with an open center. With more than one data series, Excel draws a ring for each series, so the chart can compare the composition of several groups using the same set of categories. For example, a retailer might use one ring for sales in 2024 and another for sales in 2025, with each ring divided into the same product categories.

Each ring represents one series, not one category. A ring’s slices correspond to the categories in the data, such as product lines, departments, or response types. The center hole is part of the chart’s design; it does not represent an extra data series or a value unless you add a separate text box or label yourself.

This format is most useful when the reader needs to compare parts of a whole across a small number of groups. It is less effective for precise comparisons, because slice angles are harder to compare than bar lengths, especially when there are many categories or several rings.

Prepare the source data

Use one category column and one column for each ring. Put series names in the header row and keep category names in the first column. For instance, this layout compares the mix of sales across three years:

  • Column A: product category, such as Books, Clothing, and Home.
  • Columns B through D: one year per series, with the year in the header.
  • Each row: the value for that category in each year.

Keep the category rows in the same order for every series. Excel uses the row alignment to associate a slice with a category, so a blank or misplaced row can make an apparent comparison misleading. If a category has no value in one period, use a zero when that is what the data means; use a blank only when the value is genuinely unavailable or not applicable.

Use nonnegative numbers. Doughnut charts are intended to represent parts of a whole and do not communicate negative contributions meaningfully. Also check that the values within each series make sense as a whole. If one column contains counts and another contains percentages, the chart can still draw rings, but comparing their slice sizes as if they shared a common scale would be confusing.

Create the chart in Excel for Windows

  1. Select the complete rectangular range, including the category labels and series headings.
  2. Choose Insert > Insert Pie or Doughnut Chart > Doughnut.
  3. Check that the rings and slice labels reflect the intended series and categories. If Excel has interpreted rows and columns the wrong way, select the chart and choose Chart Design > Switch Row/Column.
  4. Add a useful title and legend, and adjust labels and colors for readability.

For example, if A1 contains Category, B1 through D1 contain 2023, 2024, and 2025, and A2:A4 contain Books, Clothing, and Home, selecting A1:D4 gives Excel three series and three categories. The chart has three rings, one per year, with a slice for each product category in each ring. The values should be actual numeric cells; numbers stored as text may be ignored or interpreted unexpectedly.

If the chart already exists and you want to add another ring, select it and choose Chart Design > Select Data. In the Select Data Source dialog, use Add under Legend Entries (Series), then set the series name and series values. Ensure the category-label range still covers the matching category rows. Adding a column to the source table and then reviewing Select Data can be easier when the chart is linked to a regularly updated range.

Control ring order, size, and appearance

Excel’s series order determines the ring order. The first series is the innermost ring and subsequent series appear farther outward. To change that order, open Chart Design > Select Data and use the move-up or move-down controls in the series list. This changes which data series occupies each ring; it does not reorder the categories within a ring.

To adjust the center opening, right-click a ring and choose Format Data Series. In the Format Data Series pane, use Series Options > Doughnut Hole Size. A larger percentage makes the hole larger and the rings thinner; a smaller percentage makes the hole smaller and the rings thicker. The setting affects the chart’s rings together. If the chart looks crowded, try a smaller hole or reduce the number of series rather than shrinking the chart until labels become unreadable.

Choose colors consistently across rings. If the blue slice means Books in the inner ring, use the same blue for Books in every outer ring. Excel may assign colors by series or data point in ways that do not communicate that relationship clearly, so inspect and format the slices as needed. A legend can explain the category colors, while the chart title or a nearby note can identify what each ring represents.

Labels and interpretation

To show values or category names, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a label position. For more control, choose More Data Label Options in the label menu or open the Format Data Labels pane. Depending on the selected options, labels can show category name, value, or percentage. Avoid turning on every option at once: a label that includes a long category name, value, and percentage may overlap neighboring slices.

A percentage label is calculated within its own data series. If one ring totals 100 and another totals 1,000, a slice labeled 20% means one-fifth of that ring’s total in both cases; it does not mean the two slices have equal underlying values. This is a common source of confusion. A doughnut chart emphasizes each group’s composition, not absolute totals across groups. If readers need to compare total sales or counts as well as composition, include the totals in a separate table or use a companion chart.

Small slices can be difficult to label and compare. Consider combining minor categories into an “Other” group only when that grouping is meaningful and transparent. Keep the underlying detail available in the worksheet or a supporting table. Use a legend when direct labels collide, and avoid relying on color alone: clear category names and adequate contrast help readers distinguish the slices.

Limits and common problems

  • Only one ring appears: Check that the selected range includes multiple data columns, and that the chart is grouped by columns. Use Chart Design > Switch Row/Column if necessary.
  • Categories appear as rings: Excel may have treated rows as series. Switch rows and columns, then confirm the legend lists the intended series names.
  • Ring comparisons seem strange: Percentages are calculated separately for each series. Compare proportions within each ring, not slice sizes as absolute quantities across rings.
  • Labels overlap: Reduce the number of categories, use a legend, enlarge the chart, or show fewer label fields. Several rings with many thin slices are usually too dense to read.
  • A value is missing: Check for numbers stored as text, unexpected blank cells, or an incorrect source range. Review Chart Design > Select Data to see which values and labels the chart uses.

Even when Excel can draw many rings, more is not automatically better. Every extra series adds another layer for the reader to track. Two or three rings are often easier to interpret than a large stack, particularly when the purpose is to compare categories. This is a practical readability guideline, not a fixed Excel limit.

When another chart is a better choice

A multiple-ring doughnut chart is appropriate when each series is a whole made up of the same categories and the comparison is about relative share. It is a poor fit when values can be negative, when exact differences matter, or when the category lists differ substantially between groups.

For comparing category values across periods, a clustered bar or column chart makes it easier to compare lengths against a shared axis. For showing change over time, a line chart is often clearer. A 100% stacked bar chart also emphasizes proportions, but places categories along aligned bars, making corresponding shares easier to compare than slices in concentric rings. Choose the chart based on the question readers need to answer, not simply on how many series the table contains.

On Mac, the chart concepts and series layout are the same, although ribbon and pane placement can vary slightly by Excel release. Select the chart and look for the Chart Design and Format tabs, or open the formatting pane for series options. Excel for the web can create and edit charts, but some formatting controls may be more limited or arranged differently; if a specific option such as a detailed series-format setting is unavailable, open the workbook in the desktop app.

Frequently Asked Questions

Can an Excel doughnut chart have more than two rings?
Yes. Each data series can add a ring, so the chart can contain more than two. The practical constraint is readability: many rings and slices make it difficult to identify categories and compare shares.

How do I add another ring to an existing doughnut chart?
Add another data series through Chart Design > Select Data > Add, then specify its name and values. The new series becomes another ring. Check the category-label range and series order afterward.

Which ring is the first data series?
Excel places the first series in the center, with later series arranged outward. Change the series order in the Select Data Source dialog if you want a different ring sequence.

Do percentages add up across all the rings?
No. Each ring’s percentages are based on that ring’s own total. A 25% slice in one ring and a 25% slice in another each represent one-quarter of their respective series totals.

Can I make the hole larger or smaller?
Yes. Right-click a ring, choose Format Data Series, and adjust Doughnut Hole Size under Series Options. The change adjusts the hole and ring thickness for the chart.

Why does my chart show one ring instead of several?
The selected range may contain only one series, or Excel may have read the data orientation differently. Include all series columns and use Chart Design > Switch Row/Column to correct the grouping.

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.