To create a double doughnut chart in Excel for Microsoft 365, put the category names in the first column and the values for two data series in the next columns, select the whole range, then choose Insert > Insert Pie or Doughnut Chart > Doughnut. Excel draws one ring for each series, so you can compare the same categories across two groups or periods.
What a double doughnut chart shows
A double doughnut chart is a standard Excel doughnut chart with two data series, shown as concentric rings. Each ring is divided into slices for the categories in your data. For example, the inner ring could show sales channels in April and the outer ring could show the same channels in May. The hole in the middle is simply part of the chart design; it does not represent a data value.
The key point is that each ring represents a separate whole. Excel calculates each slice as a proportion of the total for its own data series. Thus, a chart can show the composition of two groups even when their raw totals differ. It is useful for showing how a mix changes, but it is not a direct display of total size.
People sometimes expect the outer ring to be a second level of breakdown, such as a category split into subcategories. That is not what adding a second series does: it creates another ring with its own set of category values. For hierarchical data, a sunburst chart may be a better fit.
Arrange the data before inserting the chart
Use one row per category and one column per series. Include a header row and a category-label column, with no blank rows or columns inside the selected range. For example:
| Channel | April | May |
|---|---|---|
| Store | 40 | 45 |
| Online | 35 | 30 |
| Partner | 15 | 15 |
| Other | 10 | 10 |
In this example, each month totals 100, making the percentages easy to inspect. The values do not have to add up to 100: Excel converts each series into slices relative to that series’ total. For instance, April’s Store slice is 40% of April’s 100, while May’s Store slice is 45% of May’s 100.
Keep the category labels consistent between the two series. If the second column describes different categories, matching slice colors and comparing category changes becomes confusing. Also check that the values are numeric and nonnegative. A zero has no visible slice; negative values do not represent a meaningful share and can make a doughnut chart unsuitable.
Insert a double doughnut chart in Excel
- Enter the category names and the two series, including descriptive column headings.
- Select the complete range, including the headings. For the example above, select A1:C5.
- On the ribbon, choose Insert > Insert Pie or Doughnut Chart > Doughnut.
- Check that the chart has two rings and that the category names appear around the chart. If Excel arranged the data incorrectly, select the chart and choose Chart Design > Switch Row/Column.
- Click the chart title and type a title that identifies both groups or periods, such as Sales mix: April and May.
On Excel for Mac, the chart is also inserted from the Insert tab using the pie or doughnut chart menu; the ribbon layout may differ slightly depending on the window size. Excel for the web has chart insertion and formatting options too, but some advanced formatting controls and panes can be arranged differently from the Windows desktop app.
Excel normally uses the first data series for the inner ring and the next series for the outer ring. If you add a series later, or want to reverse the order, select the chart and open Chart Design > Select Data. In the data source dialog, adjust the series order with the available up and down controls. Verify the result visually because the order affects which period readers see nearer the center.
Format the rings and make the comparison readable
A double doughnut chart can become hard to read when slices are narrow, labels collide, or the two rings use unrelated colors. A little restrained formatting usually works better than adding many effects. Use the same color for the same category in both rings so a reader can follow that category from one period to the other. For example, make Online blue in both rings, even if its percentage changes.
To change a slice, click the chart and then click the slice again to select that individual data point. Use the formatting options for the selected point to change its fill. Take care to select a point, not the entire series: changing a series affects every slice in that ring. If the categories are in a fixed order, keeping their order the same across both series also makes the comparison easier.
Use a simple chart title and, where needed, a legend that names the categories. Avoid relying on color alone if the chart will be viewed in print or by people with color-vision differences. Direct labels can help, but putting category names and percentages on every slice may clutter the chart. If there are many categories or several tiny values, consider labeling only the most important slices or choosing a different chart.
Add labels and understand their percentages
To add labels, select the chart and choose Chart Design > Add Chart Element > Data Labels, then choose a placement. For more control, choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select the items you want, such as Category Name, Value, or Percentage. The options available can vary with the selected chart element.
Percentage labels show each slice as a share of its own ring’s total, not as a share of the combined total of both rings. In the example, April Store is 40% and May Store is 45%. A label saying 45% does not mean May’s Store sales were necessarily larger in absolute terms: the series totals might be very different. If absolute totals matter, show those totals separately in the chart title, a nearby cell, or a data table.
When labels overlap, try a different label position or remove unnecessary label components. You can also enlarge the chart area or reduce the number of categories by combining small, related categories into an Other group, provided that grouping is appropriate for the data. Do not use rounding that makes displayed percentages appear to total much more or less than 100%; whole percentages may add to 99% or 101% because of rounding.
When this chart works—and when it does not
Two rings are most useful when the reader needs to compare composition across two groups with the same categories, such as this month versus last month, actual versus planned mix, or two regions. The chart emphasizes each group’s proportions. It does not make precise differences between slices easy to judge, because angles and ring positions are harder to compare than aligned bar lengths.
A common misconception is that a double doughnut chart compares the size of the totals. It does not: each ring is scaled to its own total. If one group has 1,000 units and another has 100, the two rings can still look equally large. Include the totals elsewhere if scale matters, or choose a chart that displays values on a common axis.
For a large number of categories, small changes, or precise comparisons, a bar chart is often clearer. A 100% stacked bar chart also compares composition, while placing the two groups side by side on a shared scale. If the question is about how much each category changed rather than each group’s share, use a clustered bar or column chart with raw values.
Common problems and quick fixes
- Only one ring appears: Check that the selected range includes two value columns as well as the category names. If the source is correct, try Chart Design > Switch Row/Column.
- Headings or categories are plotted as values: Re-select the data with its header row and category column, then insert the chart again. Check the chart’s data source if Excel has guessed the series orientation incorrectly.
- Category labels are missing or wrong: Use Chart Design > Select Data to review the category-axis label range and the series included in the chart.
- A slice is absent: Check for a zero, a blank, text stored in place of a number, or a very small value. Correct the source data or display the value in a more suitable chart.
- The rings seem to tell the same story: Confirm that the series contain the intended values and that each ring is identified. Since each ring is normalized independently, also compare its underlying total before drawing conclusions.
- Labels are crowded: Reduce label detail, move labels, enlarge the chart, or switch to bars if the categories cannot be read clearly.
Alternatives and useful design choices
Choose the chart based on the comparison the audience needs to make. A double doughnut chart is a compact way to show two compositions, especially in a dashboard with a small number of categories. A 100% stacked bar chart is usually better for comparing category shares across several groups, since corresponding segments can be compared along a common baseline. A regular clustered bar chart is better for comparing actual amounts rather than percentages.
If you want a central label, Excel does not require the hole to contain anything. You can leave it empty, or add a text box with a concise total or caption. If you use a text box, make sure it remains legible and does not imply that the center is a third data series. A subtitle or a small table can be a clearer place for totals and definitions.
For three or more periods, adding more rings may technically show the series, but each ring becomes harder to compare and the chart can look crowded. A line chart, 100% stacked bar, or small multiples may communicate the trend more clearly. The fact that Excel can add another ring does not mean extra rings improve the explanation.
Frequently Asked Questions
Can Excel make a doughnut chart with two rings?
Yes. Include two data series in the selected source range and insert a Doughnut chart. Excel displays the series as concentric rings, with category slices in each ring.
How do I make the outer ring show the latest month?
Put the earlier month in the first series and the latest month in the second, then check the chart’s ring order. If needed, use Chart Design > Select Data to change the series order. Excel generally places the first series on the inner ring.
Can the two rings have different totals?
Yes. Excel calculates each ring’s slice percentages from that ring’s own total. Because of this, the chart compares composition, not the absolute size of the two totals.
How do I show percentages on a double doughnut chart?
Select the chart and choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select Percentage. Each percentage refers to its own series total.
Why does my chart show one ring instead of two?
The selected range may contain only one value series, or Excel may have interpreted rows and columns in the wrong direction. Include both value columns and try Chart Design > Switch Row/Column.