Excel Explode Pie Chart Slice: How to Pull One Out

To explode one slice in an Excel pie chart, click the chart, click the slice a second time to select just that data point, and drag it away from the pie. For a precise setting, right-click the selected slice, choose Format Data Point, then adjust Point Explosion in the pane.

What an exploded pie slice does

An exploded slice is separated slightly from the rest of a pie chart. The gap draws attention to that category without changing its value or the proportions represented by the chart. For example, if a chart shows product sales and one category is unusually large, pulling that slice outward can help readers notice it quickly.

“Explode” is a chart-formatting term, not a data operation. Excel does not move the category to another position in your worksheet, recalculate its total, or remove it from the pie. The slice remains part of the same chart and keeps its original size relative to the other slices.

Use the effect sparingly. A small separation can emphasize one important category; pulling several slices far away can make the chart harder to read and weaken the sense that all slices belong to one whole. If you need to highlight a value with exact comparisons, a bar chart may communicate it more clearly.

Drag one slice away from the pie

In Excel for Microsoft 365 on Windows, first select the chart, then select the individual slice. The first click on the pie commonly selects the entire data series; clicking the same slice again selects that data point. Take care not to double-click rapidly, which may open a formatting dialog or make selection less predictable.

Click the pie chart once so Excel displays the chart selection handles and chart tabs on the ribbon.
Click the slice you want to emphasize once. The whole pie series may appear selected.
Click that same slice again, more deliberately. Selection handles should now indicate that only one slice is selected.
Point to the selected slice, hold the mouse button, and drag it a short distance away from the chart’s center. Release when the gap looks appropriate.

If the whole pie moves, you selected the chart area rather than a slice. If all slices move apart, you selected the series or changed the setting for the entire data series. Undo the change if needed, then select the specific point again. The exact appearance of selection handles can vary with the chart style, so confirm the result visually: only the chosen wedge should separate.

Set the separation precisely in Format Data Point

Dragging is quick, but the formatting pane is useful when you want a controlled adjustment or need to revisit the setting later. Select the individual slice, right-click it, and choose Format Data Point. In the Format Data Point pane, open Series Options and adjust Point Explosion. Depending on the pane layout, you may need to select the Series Options icon or expand its heading to reveal the control.

Point Explosion is a percentage-style setting that controls how far the selected point is offset. Increase it to create a wider gap and decrease it to bring the slice closer to the pie. The exact visual distance depends on the chart’s size, so judge the result in the context of the finished chart rather than expecting the same number to produce identical spacing in every layout.

To restore a slice to the pie, select that point and set Point Explosion back to zero, or drag it back into place. If you have changed the entire series instead, use Format Data Series and reduce the series-level Pie Explosion setting. Resetting the relevant control is more reliable than trying to line up a slice by eye.

Explode one slice versus the whole pie

Excel can separate a single data point or create gaps between every slice. These are different formatting choices, and selecting the right object matters:

One slice: Select the data point and change Point Explosion. This is best for highlighting a particular category.
All slices: Select the data series and adjust Pie Explosion under Series Options. This separates the entire pie into wedges.
A different slice: Select that point and set its own explosion amount. Individual slices can have different offsets, although inconsistent gaps can look untidy.

For instance, imagine a pie with four categories: North, South, East, and West. If East is the category you want readers to notice, explode only East. If every category needs a distinct visual boundary, a slight series-wide separation may work, but adding a gap to every slice is not the same as emphasizing East alone. Keep the chart’s purpose in mind: decoration should not make comparisons more difficult.

Choose a useful amount and keep the chart readable

There is no universal explosion amount that suits every chart. A small offset is usually enough to signal emphasis while keeping the slice connected visually to the whole. A large offset can make a pie look fragmented, cause labels to collide, or leave the reader unsure which wedge belongs to which label. Check the chart at the size at which people will actually see it, including in a printed page or presentation.

Before separating a slice, consider whether the category is meaningful enough to single out. Pulling out a tiny slice can make it more noticeable, but it does not make its value larger. A data label showing the category name and percentage can provide context. To add or review labels, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a placement that does not obscure the wedges. Ribbon labels can differ slightly depending on the chart selection and Excel build.

Also check the source data. A pie chart is most informative when its categories are parts of a meaningful whole and use comparable, nonnegative values. If a chart has many tiny categories, exploding one may not solve the main problem; grouping small categories or choosing a bar chart can make the information easier to compare.

Common selection and formatting problems

The whole pie separates: Excel has the data series selected. Undo, select the desired slice again, and look for selection handles on just that point before dragging or opening Format Data Point.
The chart moves instead of the slice: The chart area or plot area is selected. Click directly on the colored wedge, not the blank background, and click the wedge again to target the point.
The slice will not drag: Check that the individual data point is selected. You can use the Format Data Point pane instead, which avoids relying on a precise drag.
Labels overlap after exploding: Reduce the separation, move or reposition labels, enlarge the chart, or use a legend. A visually striking offset is not helpful if it hides the category names.
The gap looks different after resizing: Chart dimensions and layout affect the visual result. Recheck the explosion amount after changing the chart size or moving it to another sheet or presentation.

If the pane does not show Point Explosion, check that you opened Format Data Point for a selected slice rather than formatting the chart area, title, or legend. Excel for the web and some older builds may present fewer chart-formatting controls or a different interface. When the point-level setting is unavailable, open the workbook in the Excel desktop app for Microsoft 365 and make the adjustment there.

Excel on Mac and Excel for the web

Excel for Microsoft 365 on Mac uses the same basic idea: select the chart, select the individual pie point, and drag it outward, or open the point’s formatting pane and adjust its explosion setting if available in that build. Context menus are opened with a secondary click; depending on the mouse or trackpad setup, that may mean a two-finger click or Control-click. Ribbon and pane placement can differ from Windows, but the distinction between formatting a data point and formatting the whole series still applies.

Excel for the web may allow basic chart selection and editing, but chart-formatting controls are not always identical to the Windows desktop app and can change as the service is updated. If you cannot find the point-level explosion control, use Open in Desktop App and edit the chart in Excel for Microsoft 365 on Windows or Mac. This is preferable to repeatedly dragging when you need a consistent, deliberate amount.

When another chart is a better choice

Exploding a slice is a formatting choice, not a fix for every pie-chart problem. Pie charts rely on readers comparing angles and areas, which becomes difficult when there are many categories or when several values are close together. If the goal is to compare categories precisely, a bar or column chart usually makes differences easier to judge because the values share a common scale.

A doughnut chart can offer a similar part-to-whole appearance with space in the center, and it also supports separating points in compatible Excel versions. It does not automatically improve comparisons, however. For a small number of categories that add up to a clear total, a restrained exploded pie can be effective. For many categories, changing the chart type is often clearer than pulling slices farther apart.

Frequently Asked Questions

Can I explode just one slice in an Excel pie chart?
Yes. Select the chart, click the target slice again so only that data point is selected, then drag it outward. For a more controlled adjustment, right-click the slice, choose Format Data Point, and change Point Explosion.

How do I pull a pie slice back into place?
Select the separated slice and drag it toward the center, or set its Point Explosion value to zero in the Format Data Point pane. If all the slices are separated, adjust the series-level Pie Explosion setting instead.

Why does Excel move every slice when I drag one?
You likely selected the entire pie series rather than an individual data point. Undo the movement, click the chart, then click the desired wedge a second time before dragging. Confirm that only that wedge is selected.

Can different slices have different explosion amounts?
Yes. Select each slice separately and set its Point Explosion amount. Use different amounts only when they communicate something intentional; inconsistent spacing can make the chart look disjointed.

Does exploding a slice change its value?
No. It changes only the slice’s position in the chart. The worksheet data, total, and proportional angle of the slice remain unchanged.

Can I explode a slice in Excel for the web?
Available chart controls can differ from the desktop app. If you do not see a point-level explosion setting in the web interface, open the workbook in the Excel desktop app and format the selected data point there.

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.