Friday, July 19, 2013

How to Create an Exploding Pie Chart in Excel


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.

Blogger news