Exploded Doughnut Chart in Excel: How to Make One

Charts & pivot tables · Updated November 19, 2026

To make an exploded doughnut chart in Excel for Microsoft 365 on Windows, select your category-and-value data, choose Insert > Insert Pie or Doughnut Chart > Doughnut, then right-click the chart series and select Format Data Series. In the formatting pane, adjust Doughnut Explosion to pull the slices apart; to move just one slice, select that slice separately and adjust Point Explosion instead.

What an exploded doughnut chart shows

A doughnut chart displays values as segments around a central hole. Each segment represents a category, and its share of the complete circle corresponds to that category’s proportion of the total. An exploded doughnut chart adds space between the segments, making the boundaries more noticeable. You can separate every segment equally or emphasize one selected segment by pulling it farther away from the center.

For example, suppose a report shows 120 support requests: 60 about billing, 36 about delivery, and 24 about account access. The chart can show those as 50%, 30%, and 20% of the total. Pulling the billing segment outward can draw attention to it, but the chart still represents the same values; explosion changes the appearance, not the data.

The term can be confusing because Excel does not offer a separate chart type named Exploded Doughnut. You first insert a standard doughnut chart and then change the spacing of its data points. A pie chart can also be exploded, but it has no central hole. If you want the hole, choose Doughnut.

Prepare the source data

Arrange the source data with one category column and one numeric-value column. Include a clear heading for each column, and exclude any grand-total row from the chart selection. For example:

  • Category in A1:A4: Request type, Billing, Delivery, Account access.
  • Value in B1:B4: Count, 60, 36, 24.

Select the headings and category rows together, such as A1:B4. Excel uses the category names for the slices and the values to calculate their relative sizes. A total row is usually unnecessary: Excel calculates the total from the plotted values, and including a total as another category would make the chart misleading by counting that total as a slice.

Use values that are meaningful parts of one whole. Doughnut charts are a poor fit when the numbers are unrelated, when categories overlap, or when the values include negative numbers. A chart of monthly revenue by product can make sense if each product contributes to the same total; comparing temperatures in several cities does not naturally describe parts of one whole.

Create the doughnut chart in Excel

  1. Select the category and value cells, including their headings.
  2. On the ribbon, choose Insert > Insert Pie or Doughnut Chart.
  3. Choose Doughnut from the chart gallery.
  4. Click the chart to reveal its chart tabs, then right-click a doughnut segment and choose Format Data Series.
  5. In the Format Data Series pane, open Series Options and adjust Doughnut Explosion until the gaps are visible.

The explosion control is a percentage-style setting: increasing it moves the segments farther apart. The exact visual result depends on the chart size and the number of categories, so adjust it while viewing the chart rather than relying on a fixed value. If the pane is not visible, right-click the chart series again and choose Format Data Series. You can also open the format pane by selecting the series and using the chart formatting controls on the ribbon.

For Microsoft Excel for Mac, the same general method applies: insert a Doughnut chart, select its series, and open the formatting pane to find the explosion option. Ribbon placement and pane presentation can vary slightly between releases. Excel for the web may expose fewer chart-formatting controls than the desktop app; if you cannot find the explosion setting, open the workbook in desktop Excel.

Explode every slice or just one

The Doughnut Explosion setting applies spacing across the series. Use it when you want a consistent gap around the entire ring. A subtle separation often improves legibility without making the chart look scattered. If the gap is too large, the segments appear detached, and readers may have to work harder to judge the relationship between them.

To emphasize only one category, select an individual data point rather than the whole series:

  1. Click the chart once to select the doughnut series.
  2. Click the target segment again, carefully, so only that slice is selected.
  3. Right-click the selected slice and choose Format Data Point.
  4. In the Format Data Point pane, adjust Point Explosion.

The first click generally selects the series; the second click selects the individual segment. Check the selection before changing the setting: if every slice moves, you have formatted the series rather than one point. To return the highlighted slice, reduce its Point Explosion value. You can use both approaches, but a small series-wide gap plus a modest extra offset for one important category is usually easier to read than large offsets everywhere.

Format the chart so the data stays clear

Explosion is a visual emphasis, not a substitute for labels or a sensible category order. Add labels when readers need exact values or category names. Select the chart, then use Chart Design > Add Chart Element > Data Labels to choose a label position. You can also use the Chart Elements button beside a selected chart, where available, to turn labels on. Right-click a label and choose Format Data Labels to control which information appears, such as category name, value, or percentage.

For the support-request example, category names and percentages may be enough. If all three values matter, display the counts as well, but avoid crowding the ring with several pieces of information per slice. A legend can identify colors, though direct labels can be easier to scan when the chart has only a few categories. Use a descriptive chart title and consistent colors; reserve a distinct accent for a slice you have intentionally highlighted.

The center hole is also adjustable. Select the series, open Format Data Series, and change Hole Size. A larger hole leaves less room for the ring, while a smaller hole makes the ring thicker. If you place a total in the center, make sure it is the total of the displayed categories and that the text remains readable. Excel does not automatically turn the hole into a total label; that is a separate design choice.

Choose a doughnut chart when it fits

A doughnut chart works best for a small set of categories that add up to a meaningful whole. There is no universal category limit, but many narrow segments, similar values, or long category names make the chart difficult to interpret. Consider combining genuinely minor categories into an accurately named group only when that grouping is appropriate for the data and audience. Do not hide material categories just to make the graphic look simpler.

Use an exploded version sparingly. Pulling a slice out can signal importance, but it can also make that category seem more important than its value warrants. If the goal is simply to compare category sizes, a regular doughnut or a bar chart may communicate the comparison more neutrally. A bar chart is particularly useful when values are close, because readers can compare lengths more accurately than angles or arc areas.

A doughnut differs from a pie chart mainly by the hole in the center; both show parts of a whole. A stacked bar chart can be a better choice when you need to compare composition across several groups, such as product mix for multiple regions. Excel doughnut charts can use multiple data series, which appear as concentric rings, but multiple rings are not automatically a good comparison: matching categories and scales can be hard to follow. For a single simple breakdown, start with one series.

Common problems and fixes

  • The chart looks like a pie chart. Confirm that you inserted Doughnut rather than Pie from the chart gallery. If the center hole is merely small, increase Hole Size in Format Data Series.
  • All slices move when you intended to move one. The series is selected. Click the segment a second time, confirm that only that point is selected, and use Format Data Point.
  • The slices have gaps but one category is not emphasized. Series-wide Doughnut Explosion separates all points evenly. Select the individual category and change Point Explosion for a separate offset.
  • Labels overlap or are cut off. Enlarge the chart, use fewer label fields, choose another label position, or move the legend. With many categories, use a bar chart or a data table instead.
  • The chart includes an unexpected slice. Check the selected source range for a total row, blank cells, or an unintended column. Use Chart Design > Select Data to review or change the chart’s data range.

If the chart does not update after you edit a value, check that the cell is inside the chart’s source range. Select the chart and use Chart Design > Select Data to inspect the range. If the source is an Excel table, adding a new row may extend the chart automatically, but confirm the result, especially if the chart uses a range outside the table or contains manually selected cells.

Frequently Asked Questions

Can I explode only one slice in an Excel doughnut chart?
Yes. Select the chart series, click the desired segment again to select that data point, right-click it, choose Format Data Point, and adjust Point Explosion. If the whole ring changes, select the individual segment again.

Where is the Doughnut Explosion setting in Excel?
Right-click a doughnut segment and choose Format Data Series. In the pane, open Series Options and adjust Doughnut Explosion. For one segment only, select that point and use Format Data Point instead.

Can an exploded doughnut chart show percentages?
Yes. Select the chart and add Data Labels, then format the labels to display percentage. Confirm that the values are parts of the intended total; percentages are calculated from the plotted series and may not match a different denominator you use elsewhere.

Can I put a total in the center of a doughnut chart?
Yes, but Excel does not add it automatically. You can add a text box to the chart and position it in the hole, then keep the displayed total synchronized with your source data. Make sure the text does not obscure the chart or imply that a subtotal is the whole.

Why can’t I find the explosion option in Excel for the web?
Chart-formatting controls can differ between Excel for the web and desktop Excel. Open the workbook in the Microsoft 365 desktop app for Windows or Mac and look in the Format Data Series or Format Data Point pane.

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.