This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

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.

return to topCreating 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.

  1. Select the data to be charted

  2. On the Standard toolbar, click CHART WIZARDChart Wizard button
    The Chart Wizard - Step 1 of 4 - Chart Type dialog box appears.

  3. From the Chart type scroll box, select Pie

  4. Under Chart sub-type, select one of the exploded pie charts

  5. Click NEXT

  6. Complete your chart
    NOTE: For more information, refer to Using the Chart Wizard.

return to topExploding 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

  1. Click your pie chart to select it

  2. From the Chart menu, select Chart Type...
    The Chart Type dialog box appears.

  3. From the Chart type scroll box, select Pie

  4. Under Chart sub-type, select one of the exploded pie charts

  5. Click OK
    The chart type is changed.

Exploding All Pie Slices

  1. Click your pie chart to select it

  2. Click any pie slice and drag it outward
    The pie slices appear exploded.

Exploding a Single Pie Slice

  1. Click your pie chart to select it

  2. To select a pie slice, click it once

  3. Click and drag the selected slice outward
    The selected slice appears exploded.
    Pie chart with a single exploded slice

Excellence. Our Measure. Our Motto. Our Goal.