Multiple Doughnut Charts in Excel: How to Make Them

Charts & pivot tables · Updated November 20, 2026

To make a multiple-ring doughnut chart in Excel, arrange each data series in its own column (or row), select the category labels and values, then choose Insert > Insert Pie or Doughnut Chart > Doughnut. Excel draws one concentric ring for each series; if you mean several separate doughnut charts, create one chart per data set and arrange them side by side.

What a Multiple Doughnut Chart Shows

A doughnut chart is a pie chart with an open center. In Excel, a standard doughnut chart can plot several data series at once, displaying each series as a ring around the same center. Each ring is divided into slices for the categories in the source data. This makes it possible to compare the composition of categories across periods, groups, or scenarios in one compact graphic.

For example, a chart could show the share of orders by channel in 2024 and 2025. The inner ring might represent 2024 and the outer ring 2025; each ring contains slices for Website, Store, Partner, and Phone. The same categories should appear in the same order for every series so that corresponding slices can be compared visually.

The phrase multiple doughnut charts can also mean several independent charts on a worksheet. Those are different from a multi-ring chart: each independent chart has its own categories and values, while a multi-ring chart uses one shared category structure and one ring per series. Choose based on whether you want to compare composition within related groups or show unrelated summaries separately.

Prepare Data in a Clear Layout

Put category names in the first column and each series in a separate adjacent column. Use one header row to name the series. For instance, this table compares the percentage mix across two years:

Channel 2024 2025
Website 40 45
Store 30 25
Partner 20 18
Phone 10 12

The numbers in each year total 100, but they do not have to be entered as percentages. Excel calculates the slice sizes from the values in each series. If your source data is counts, such as 400 website orders and 300 store orders, the ring represents each count as a proportion of that series total.

  • Keep the category list consistent across series. A missing or differently ordered category can make comparisons confusing.
  • Use descriptive headers; Excel can use them to identify the rings in the chart legend.
  • Avoid including grand-total rows in the selected range. A total is not another category and can distort the display.
  • Check that the values are numeric and that each series has a meaningful total greater than zero.

For a horizontal layout, put the category names in the first row and each series on its own row instead. Excel may infer the direction from the selected range. You can switch it after insertion if the rings and labels do not match your intention.

Create a Multi-Ring Doughnut Chart

In Excel for Microsoft 365 on Windows, use the following steps:

  1. Select the full range, including the category labels and series headers. In the example above, that means all three columns and the five rows.
  2. Open the Insert tab, choose Insert Pie or Doughnut Chart in the Charts group, and select Doughnut.
  3. Check that the chart has one ring for each year and that the category names appear as intended. If Excel has treated rows as series instead of columns, select the chart and choose Chart Design > Switch Row/Column.
  4. Move or resize the chart by dragging it, or use the sizing controls on the Format tab when the chart is selected.

The chart title, legend, and ring order can be refined after it is created. To change the series order, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, select a series under Legend Entries (Series) and use Move Up or Move Down. The order affects which series is placed toward the center and which is toward the outside, so verify the result in the chart rather than assuming a particular order.

Excel for Mac offers doughnut charts as well, although the ribbon arrangement and wording can vary slightly by release. Look on the Insert tab for the pie or doughnut chart choices, then use the chart design and formatting controls for series, labels, and layout. Excel for the web has chart creation and editing tools too, but some detailed formatting options may be more limited than in the desktop application.

Format Rings, Colors, and the Center

Click the chart, then click the ring you want to change. Right-click it and choose Format Data Series to open the formatting pane. The Doughnut Hole Size control changes how wide the center opening is: a larger hole leaves thinner rings, while a smaller hole makes the rings thicker. Pick a size that leaves enough room for visible slices and labels; very thin rings are difficult to read.

The Format Data Series pane also includes Angle of first slice. Adjusting that setting rotates the slices around the center. This is useful when you want a key category to start near the top or when aligning matching categories across multiple charts. It does not change the values or their proportions.

Use colors consistently. If Website is blue in the first ring, it should remain blue in the second ring. This lets readers compare matching categories without relying only on a legend. To change one slice, select the data point rather than the whole series and use the formatting pane’s fill controls. Avoid using many nearly identical colors, especially when there are several categories.

You can add a chart title and legend from Chart Design > Add Chart Element. A short, specific title should say what the measure and grouping represent, such as Orders by Channel, 2024 and 2025. A legend is useful when colors stand for categories, but it can take up space; position it below or beside the chart if it does not obscure the rings.

Add Labels Without Overloading the Chart

To add labels, select the chart and choose Chart Design > Add Chart Element > Data Labels, then select a position. For more control, right-click a label and choose Format Data Labels. Depending on the label options available for the selected chart, you can show category names, values, or percentages. Percentage labels indicate each slice’s share of its own ring, not its share of all the values across every ring.

It is usually clearer to label only the most important information. A chart with many slices and several rings can become crowded if every slice has a category name, value, and percentage. One practical approach is to keep a category legend, show percentages on the slices, and put the exact underlying values in a nearby table. If several slices are too small to fit readable labels, simplify the categories or use a different chart type rather than shrinking the text until it is illegible.

Excel does not automatically turn the empty center into a meaningful total for all rings. You can place a text box over the center if a central note is useful, but treat that text as a separate annotation and update it when the data changes. A center label is not a built-in sum of the series and can mislead readers if its meaning is not clear.

Interpretation and Important Limitations

Each ring is normalized to its own series total for the purpose of showing slice proportions. In the example, Website is 40 out of 100 in 2024 and 45 out of 100 in 2025, so its slice grows slightly. If the 2025 values were counts totaling 10,000 and the 2024 values totaled 1,000, the ring sizes would still show proportions, not the tenfold difference in overall volume. The chart does not encode each series’ total through ring area.

This is a common source of confusion: a larger-looking slice in one ring does not necessarily represent a larger raw count than a smaller slice in another ring. It means the category takes a larger share of that ring’s own total. If absolute totals matter, put them in labels or a separate table, or use a chart type that compares values directly, such as a clustered column chart.

Doughnut charts also make precise comparisons harder than aligned bars. Readers can see a broad shift in composition, but judging small differences in angles is difficult. Use only a modest number of categories, keep the order and color mapping consistent, and consider a bar chart when ranking or comparing exact values is the main goal.

Use Separate Doughnut Charts for Different Data Sets

If the data sets do not share categories, create separate charts rather than forcing them into rings of one chart. For each chart, select its own category labels and values and insert a doughnut chart. Then make the charts comparable by giving them clear titles, using consistent colors where categories overlap, and keeping their dimensions similar.

To lay out multiple charts neatly, drag them into a grid and use Excel’s alignment tools on the Shape Format tab when the charts are selected. Make sure each chart has enough room for its legend and labels. If the worksheet is a dashboard, consider hiding unnecessary gridlines and using a consistent font and title style. These design changes affect presentation only; the chart still references the original cell ranges.

When you copy a chart, the copy may remain linked to the same source data. If you need a separate chart for a different range, select the copied chart and use Chart Design > Select Data to change its source, or create the new chart from the other range directly. Check the chart after editing, since an accidentally shared range can make two visuals appear to show the same data.

Common Problems and Fixes

  • Only one ring appears: Check that the selected range includes multiple value columns or rows. Use Chart Design > Select Data to confirm that every intended series is listed.
  • Categories appear as rings: Excel may have interpreted the data orientation incorrectly. Choose Chart Design > Switch Row/Column and review the result.
  • Labels repeat or are hard to read: Reduce the number of displayed label fields, enlarge the chart, or rely on a legend for category names.
  • A slice takes up the whole ring: Check for a value that is much larger than the others, a total row included as a category, or values stored as unintended numbers.
  • Rings look too thin: Open Format Data Series and reduce Doughnut Hole Size. A chart with many series may still be difficult to read, so consider separate charts instead.
  • Colors do not match between charts: Set category colors deliberately and retain the same category-to-color mapping across the worksheet.

Frequently Asked Questions

Can Excel put two doughnut charts in one chart?
Yes. Add two or more data series to a single doughnut chart, and Excel displays one ring per series. Use separate chart objects instead when the data sets have different categories or need independent scales and labels.

How do I add a second ring to a doughnut chart?
Add another series to the chart’s source data, then select the chart and use Chart Design > Select Data to include it if Excel does not add it automatically. The added series should have values aligned with the same category list.

Can I make the inner ring represent the latest year?
Yes. Use Chart Design > Select Data and move the series up or down in the series list. Confirm the inner and outer positions visually, because the series order determines the ring order.

Do the percentages across all rings add up to 100 percent?
Each ring’s category percentages add up to 100 percent separately, assuming the series contains valid positive values. Percentages from different rings should not be added together.

Can I compare the total size of each series with a doughnut chart?
Not reliably from ring size. Doughnut rings show each series’ composition, not its overall total. Display totals separately or choose a chart designed to compare absolute values.

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.