Explode Pie Chart in Excel: Steps and Formatting Tips

To explode a pie chart in Excel, select the chart, select the slice you want to move, open Format Data Point, and increase Point Explosion under Series Options. You can also drag a selected slice outward, or adjust the explosion for the entire pie series to separate every slice.

What an Exploded Pie Chart Shows

An exploded pie chart pulls one or more wedges away from the center of the pie. The slices still represent the same values and proportions; the gap is a visual emphasis, not a change to the data. People commonly use the effect to draw attention to a particular category, such as a product that accounts for a notable share of sales.

Excel’s explosion setting controls how far a slice moves from the pie. It does not create a second chart or alter the underlying worksheet values. A restrained separation can help readers spot a category, while pulling every slice far apart can make the chart harder to read because the wedges no longer form a compact whole.

Make a Pie Chart Before Exploding It

If you have not created the chart yet, arrange the categories and their values in two adjacent columns, with a heading above each column. Select the data, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. A basic pie chart is usually the clearest starting point for an exploded effect.

For example, a small table could list product names in one column and their units sold in the next. Excel uses the category names to label the slices and the numeric values to determine their sizes. Check that the selected range includes the intended categories and values, but not totals or unrelated cells. A total included as another row becomes an additional slice and distorts the proportions.

Pie charts work best when the categories are parts of one meaningful whole and there are only a few slices. If the data contains many categories, especially several with very small values, consider grouping minor categories where that makes sense or using a bar chart instead. Exploding slices does not solve a chart that is already difficult to compare.

Explode One Slice in Excel for Microsoft 365

Click the pie chart once. This selects the chart or its data series.
Click the slice you want to emphasize once more. The second click selects that individual data point, rather than the entire series. Pause briefly between clicks so Excel can change the selection.
Right-click the selected slice and choose Format Data Point. The Format Data Point pane opens.
In the pane, open Series Options and adjust Point Explosion until the slice is separated by the amount you want.

You can also drag the selected slice outward from the center of the pie. Dragging is a quick way to set the visual spacing, while the pane is useful when you want to make a deliberate adjustment or revisit the setting later. Drag the slice back toward the center to reduce the gap.

Make sure the pane title says Format Data Point, not Format Data Series. The first applies the setting to one selected wedge; the second applies it to the whole series. If the wrong pane appears, close it and select the slice again with a chart click followed by a separate click on the same slice.

Explode Every Slice

To separate all the wedges evenly, select the pie series instead of an individual data point. Click the chart, then click a slice once so the series is selected. Right-click and choose Format Data Series, then use Series Options > Point Explosion in the formatting pane. Moving the setting away from zero pulls all slices outward by a similar amount.

The exact control may appear as a slider or a numeric field, depending on the Excel interface. If a field is available, you can enter a value; otherwise, move the slider and judge the result in the chart. The setting can be changed later, so you do not need to find a perfect value on the first try.

There is an important distinction between exploding a whole series and moving one slice. Exploding the series makes the whole pie look separated, which can emphasize that it consists of distinct categories. Exploding one point directs attention to a particular category. Select the series or point deliberately before changing the setting.

Choose the Right Amount of Separation

Use the smallest gap that makes the intended emphasis visible. A modest explosion preserves the impression that the wedges belong to one total. Large gaps can weaken that connection and make it harder to compare slice sizes, especially if labels or percentages sit around the chart edge.

One highlighted category: Pull one slice outward slightly and keep the others in place.
All categories need separation: Apply a small explosion to the series, rather than dragging each wedge to a different distance.
Precise comparison matters: Consider a bar chart. People generally compare lengths more easily than angles or areas.
Labels are crowded: Try a larger chart, fewer categories, or a different chart type before increasing the explosion.

Color can reinforce the emphasis, but avoid relying on color alone. Keep category names visible and use a clear legend or data labels. A slice that is both pulled out and given a contrasting color may attract more attention than intended, so use visual cues in proportion to the point you are making.

Format Labels and Keep the Chart Readable

To add or adjust labels, select the chart and use Chart Design > Add Chart Element > Data Labels, then choose a suitable label position. Available options can vary with chart type and layout. Right-click a label and choose Format Data Labels to control which information appears, such as category name, value, or percentage.

Percentages are often useful when the purpose is to show composition, but they should correspond to the chart’s actual values. Check that the source data contains the right categories and that any hidden or filtered rows are handled as intended. Avoid displaying category, value, and percentage all at once if the result becomes crowded. A concise legend or direct labels may be easier to follow.

After formatting, resize the chart and check it at the size where readers will see it, such as on a slide or printed page. Exploding wedges changes the space available for labels and can cause them to overlap. If the chart is meant to communicate a single important point, a descriptive chart title can state the context without asking readers to infer it from the legend.

Common Problems and How to Fix Them

The entire pie moves instead of one wedge: The series is selected. Click the chart, then click the intended slice again, and confirm that the pane says Format Data Point.
The wrong slice is selected: Close the pane, click the chart once, then click the target wedge separately. With thin slices, zooming in or selecting the point through the chart may help.
Dragging does not change the gap: Confirm that you selected an individual wedge, and drag from the slice itself rather than from the chart area or a label.
Labels overlap after explosion: Reduce the separation, reposition labels, enlarge the chart, or simplify the categories. Moving slices farther apart is not always the best fix.
The explosion control is missing: Check that the selected object is a pie data point or series. If you are using Excel for the web and the needed formatting option is unavailable in your interface, open the workbook in the desktop app.
The chart looks misleading: Confirm that the values represent parts of the same whole. Do not use explosion as a substitute for explaining what the numbers measure.

These instructions describe Excel for Microsoft 365 on Windows. Excel for Mac has similar chart selection and formatting controls, though pane placement and some ribbon details can differ. Excel for the web supports chart editing, but its available formatting controls can differ from the desktop app; if you cannot find Point Explosion, use Open in Desktop App and make the adjustment there.

Exploded Pie Charts Compared with Alternatives

An exploded pie is a formatting choice, not a separate way of calculating values. It can be useful when the audience needs to notice one category in a small, simple composition chart. It is less suitable when readers need to compare many similar-sized categories, track changes across several dates, or read exact values quickly.

A doughnut chart also shows parts of a whole and can leave an open center for a label, but it may still be difficult to compare close proportions. A bar or column chart gives categories a common baseline, making differences easier to judge. A 100% stacked bar can be useful when comparing composition across multiple groups. Choose based on the question the chart needs to answer, not just on the availability of an explosion effect.

Exploding a slice does not mean that the selected category is an additional value outside the total. It remains part of the same pie and retains its original proportion. The gap is decorative emphasis; it should not be interpreted as a change in quantity.

Frequently Asked Questions

Can I explode only one slice in Excel?
Yes. Select the chart, click the desired slice again to select that data point, then open Format Data Point and adjust Point Explosion. Check that you have selected the point rather than the full series.

How do I explode all slices at once?
Select the pie series and open Format Data Series. In Series Options, adjust Point Explosion. This separates all the wedges rather than emphasizing just one.

Can I explode a pie slice by dragging it?
Yes. Select the individual slice and drag it outward from the pie’s center. Use the formatting pane if you want to adjust the spacing more carefully or confirm whether you are formatting one point or the whole series.

Why does Excel move every slice when I try to move one?
You likely selected the series rather than an individual point. Click the chart once, then click the target slice separately. The individual-point formatting pane should be titled Format Data Point.

Can I explode a slice in Excel for the web?
Chart editing options in Excel for the web can differ from those in Excel for Microsoft 365 on Windows. If you cannot find the Point Explosion control, open the workbook in the desktop app and use the Format Data Point pane.

Does exploding a slice change its value or percentage?
No. It changes only how far the wedge is drawn from the center. The underlying cell value and the slice’s proportion of the pie remain the same.

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.