WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to explode a 3-D pie chart in Excel

January 5, 2022
5.4K Views

· Option 1:

1. Select the 3-D pie chart.

2. Click the slice we want to pull out, press the left mouse button to drag the slice out from the center of the 3-D pie chart. At this point, a blue dotted box will appear on the chart, showing where the slice is being dragged.

3. We drag this slice along the blue dotted box to the target position and then release the mouse. Then, we can separate this slice from the whole 3-D pie chart.

4. We can also select other slices and repeat the steps above. Then, we can explode a 3-D pie chart.

1.gif

· Option 2:

1. Select the 3-D pie chart.

2. Right-click the 3-D pie chart, then click Format Data Series in the pop-up menu.

3. In the SERIES OPTIONS interface on the right, go to the SERIES tab. In the SERIES OPTIONS area, we can drag the Pie Explosion slider, click the plus sign in the Pie Explosion percentage box, or enter an exact number in the box as needed.

4. Then, we can explode a 3-D pie chart.

2.gif

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.