How to Create an Exploding Pie Chart in Excel

In Microsoft Excel 2007, you have the option of creating an exploded pie chart when you create a pie chart. If you choose to create just a 2-D pie chart, you can explode the pie chart after you have created it. This is a very simple process that will take you just a few minutes but add a whole new look to your Excel spreadsheet.

Instructions

Difficulty: Easy

Things You’ll Need:

• Microsoft Excel 2007

1. Start Microsoft Excel 2007 and open an existing spreadsheet that creates a pie chart or create a pie chart from existing data in the spreadsheet.
2. Click on the pie chart to select the entire pie chart. Be careful to click in the white area of the chart so the entire pie chart is selected. You can tell the whole pie chart is selected because it will be surrounded by a light blue line.
3. Hover your mouse over the piece of pie that you want to explode. Your mouse cursor will turn into a 4-headed arrow.
4. Click and drag the slice of pie outwards, away from the rest of the pie in the chart. Notice the blue outline that will grow outside of the pie chart. This line represents how far away the pieces will explode from each other.
5. Release the mouse button. The pie chart will now be exploded with all of the slices of pie broken away from each other.
6. Click and drag the individual pieces of pie to their new location if you would like to manually adjust the exploding pie chart pieces.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.