Microsoft Excel 2003/2004
Creating Exploding Pie Charts
Exploding a pie slice can be used to draw attention to a specific portion of the pie. In Excel, you can drag the pie slices outward to explode all of the slices away from each other. For more information about creating charts, refer to Creating a Basic Chart.
Creating an Exploding Pie Chart
If you have not yet created your pie chart, use these instructions to create an exploding pie chart.
NOTE: For more information about creating charts, refer to Creating a Basic Chart.
-
Select the data to be charted
-
On the Standard toolbar, click CHART WIZARD
The Chart Wizard - Step 1 of 4 - Chart Type dialog box appears. -
From the Chart type scroll box, select Pie
-
Under Chart sub-type, select one of the exploded pie charts
-
Click NEXT
-
Complete your chart
NOTE: For more information, refer to Using the Chart Wizard.
Exploding an Existing Pie Chart
If you have already created a pie chart, you can make it an exploding pie chart by changing the chart type or by manually exploding the pie slices. You can also explode only a single pie slice.
Changing the Chart Type
-
Click your pie chart to select it
-
From the Chart menu, select Chart Type...
The Chart Type dialog box appears. -
From the Chart type scroll box, select Pie
-
Under Chart sub-type, select one of the exploded pie charts
-
Click OK
The chart type is changed.
Exploding All Pie Slices
-
Click your pie chart to select it
-
Click any pie slice and drag it outward
The pie slices appear exploded.
Exploding a Single Pie Slice
-
Click your pie chart to select it
-
To select a pie slice, click it once
-
Click and drag the selected slice outward
The selected slice appears exploded.
