To make a nested doughnut chart in Excel for Microsoft 365 on Windows, arrange each ring as a separate data series, select the category labels and values, then choose Insert > Insert Pie or Doughnut Chart > Doughnut. Each series becomes a ring; format the chart afterward to make the ring order, labels, and colors clear.
What a nested doughnut chart shows
A nested doughnut chart is a doughnut chart with two or more concentric rings. Each ring represents one data series, and each slice represents a category within that series. For example, you could compare sales by product category across two years: one ring for 2025 and another for 2026, with the same product categories in both.
Excel calculates the slice proportions separately for each ring. A slice that takes up 30% of the 2025 ring means that category accounts for 30% of the 2025 series total; it does not necessarily mean the slice has the same value as a similarly sized slice in the 2026 ring. This distinction matters when the totals for the series differ. A doughnut chart emphasizes proportions, not direct comparisons of raw amounts between rings.
The rings are concentric, but that does not automatically make the chart hierarchical. If each ring represents a different level of a genuine parent-child structure, such as region, then department, then product, a Sunburst chart may communicate that relationship more accurately.
Prepare the data before inserting the chart
For a straightforward comparison, put category names in the first column and one series per additional column. Use a heading for each series. For example:
- Column A: Product category
- Column B: 2025 sales
- Column C: 2026 sales
- Rows 2–5: Hardware, Software, Services, and Support, with the appropriate values in each year’s column
Include the headings and category labels when selecting the data, but do not include unrelated totals or blank rows. Each series should contain values for the same categories in the same order. If one category is missing for a series, enter zero when that accurately represents no amount; otherwise, decide how to handle the missing value before charting. A blank can be treated differently from a true zero in charts and may make the display harder to interpret.
Keep values nonnegative. Doughnut charts show parts of a whole, so negative values do not have a meaningful slice size. If your data includes negative amounts, or if the main goal is to compare absolute values between periods, use a chart type that can represent those comparisons directly.
Create the chart in Excel
- Select the complete table, including the category labels and series headings. For the example above, that means selecting the cells from A1 through C5.
- On the ribbon, choose Insert > Insert Pie or Doughnut Chart > Doughnut. Excel inserts a chart with a ring for each selected value series.
- Check that the categories and series are oriented correctly. Select the chart, then choose Chart Design > Switch Row/Column if Excel has treated the rows as series instead of the columns. The legend and ring count are useful clues: in the example, you want two rings, one per year.
- Give the chart a descriptive title. Select the chart title and replace the placeholder text with wording that identifies the measure and period, such as “Sales mix by product category.”
Excel usually places the first data series in the inner ring and later series in the rings farther out. If the order is not useful, select the chart and open Chart Design > Select Data. In the Select Data Source dialog, use the series list and its move controls to change the series order, then confirm the result in the chart. Check the display rather than assuming that the first column will be the outer ring.
Format the rings and labels
A chart with several rings can become difficult to read quickly. Use formatting to make its structure visible, not merely decorative. Select a ring and open the Format Data Series pane to adjust the doughnut hole size or the angle of the first slice. The hole-size setting changes the open space in the middle; the first-slice angle rotates the slices around the center. These settings affect appearance, not the underlying values.
To add labels, select the chart and choose Chart Design > Add Chart Element > Data Labels, then choose a position. You can select an individual label and use the Format Data Labels pane to choose which information to show, such as category name, value, or percentage. Showing every label option can overcrowd a chart, especially when categories have long names or there are several rings. A practical starting point is to show category names and percentages, then remove information that repeats or does not help the reader.
Use a consistent color for the same category in every ring when the purpose is to compare periods. For example, if Hardware is blue in the inner ring, make Hardware blue in the outer ring too. Excel’s Chart Design > Change Colors command can quickly change the palette, but inspect the result because chart palettes may not make corresponding slices easy to match. If needed, select a slice and apply a fill color individually. Keep strong contrast between adjacent slices and avoid relying on color alone when the chart is intended for readers who may have difficulty distinguishing colors.
A legend can identify categories, but a crowded legend may be less helpful than short labels placed on the chart. If the labels are too dense, consider moving details into a small data table beside the chart or simplifying the number of categories. Resizing the chart can create more room, but it will not solve a chart that contains too many small slices.
How to read the chart accurately
Read each ring as a separate whole. The slice angle is based on that ring’s series total, so each ring adds up to 100% when interpreted as proportions. If total sales rose substantially from one year to the next but the category mix stayed the same, the two rings could look almost identical. The chart alone would not communicate that growth in total sales. Add a separate total to the title or a nearby label, or pair the chart with a column chart or a summary table showing the totals.
Also be careful when comparing small differences in slice size. People generally find it easier to compare lengths along a common baseline than angles in a circle. A doughnut chart is most useful when the number of categories is limited and the proportions are the message. If a reader needs precise comparisons between several series, a clustered bar or column chart is often clearer.
Common problems and fixes
- There is only one ring. Confirm that the selected range contains at least two numeric data series, not just one values column. Check Chart Design > Select Data to see which series Excel included.
- The chart has many rings instead of the expected two. Excel may have interpreted rows as series. Try Chart Design > Switch Row/Column and check that each year or group is a separate column in the source table.
- Category names or values appear in the wrong places. Recheck the selected range, including its top headings and left-hand category labels. Use Select Data to inspect the series names and category labels.
- Some slices are missing or hard to see. Check for blank, text, zero, or negative entries in the source data. Small positive values can also produce very narrow slices; combining minor categories into “Other” may improve readability if that grouping is meaningful.
- The chart changes unexpectedly after editing cells. Excel charts normally update when their source cells change. If you added rows or columns outside the chart’s source range, open Chart Design > Select Data and expand the range to include them.
- The chart looks like a hierarchy but the data is not hierarchical. Multiple rings show multiple series, not proof that one category contains another. Use matching category labels and explain what each ring represents to prevent a misleading interpretation.
Nested doughnut versus other Excel charts
Use a nested doughnut when the reader needs a compact view of the composition of several related series and the categories correspond across rings. It can work well for a small comparison such as two years or two customer groups. Avoid adding rings just because more series are available: every added ring increases the effort needed to compare the slices.
Choose a Sunburst chart when the data is truly hierarchical and the goal is to show parent and child categories. In Excel, arrange hierarchical levels in separate columns, select the data, then use Insert > Insert Hierarchy Chart > Sunburst. Use a bar chart when accurate comparisons of category values across groups matter more than showing each group as a whole. A 100% stacked bar chart is another option for comparing composition across several groups while giving each group a common rectangular baseline.
These alternatives answer different questions. A doughnut emphasizes part-to-whole proportions within each series; a Sunburst emphasizes levels of a hierarchy; and a bar-based chart makes comparisons across categories easier. Picking the chart that matches the question usually improves understanding more than adding extra styling.
Frequently Asked Questions
Can an Excel doughnut chart have more than two rings?
Yes. Each additional numeric data series can add a ring. However, many rings can be difficult to compare, so use only as many as the reader can distinguish and explain clearly.
How do I change which ring is on the inside?
Select the chart and choose Chart Design > Select Data. Change the order of the series in the Select Data Source dialog using its move controls. Excel normally displays the first series in the inner ring, so rearranging the series changes the ring order.
Can each ring use a different set of categories?
A standard doughnut chart is easiest to read when every series uses the same categories in the same order. Excel plots the series against the chart’s category labels, so different category sets can lead to misleading comparisons. Use separate charts or another chart type when the groups do not share meaningful categories.
Why do two rings show similar percentages even when their totals differ?
Each ring is scaled to its own series total. Similar slice proportions indicate a similar mix, not equal totals. Include the series totals separately if the amounts themselves are important.
Is a nested doughnut chart the same as a Sunburst chart?
No. A nested doughnut chart uses separate data series as rings. A Sunburst chart is designed to represent hierarchical levels, such as a region containing departments and departments containing products.
Does the chart update when I change the source values?
Yes, it normally updates when values in its source range change. If you add new categories or series beyond the selected range, update the chart’s source range through Chart Design > Select Data.
Related
- Microsoft Excel Format Cells: A Practical Guide for Data
- Microsoft Excel Employee Schedule Template: Setup Tips
- Microsoft Excel Debt Payoff Template: Build a Reliable Plan
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Chart Axis: Switch Rows and Columns EasilyTo switch what an Excel PivotChart shows across its category axis and in its legend, select the chart,…
- How to Edit a Chart in Google Sheets: A Step-by-Step GuideTo edit a chart in Google Sheets, select it and double-click, or click its three-dot menu and choose…
- How to Save an Excel Chart as a Picture in High QualityIn Excel for Microsoft 365 on Windows, right-click the chart, choose Save as Picture, select a file type…
- Rate Graphs in A-Level Chemistry: What You Need to KnowYes. Rate graphs are an important part of A-level chemistry kinetics: you use them to show how a…
- Excel Stacked Bar Chart Combo: Build and Format ItYes, Excel can combine chart types, but a horizontal stacked bar chart paired with a line or another…
- Wedding Seating Chart in Google Sheets: A Practical GuideYes. You can make a wedding seating chart in Google Sheets by keeping guest details and table assignments…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.