Microsoft Excel Tutorials

Formatting an Excel Pie Chart

When you click the Finish button after step 4 of the Chart wizard, the wizard closes, and your new chart appears in your spreadsheet.

Your new chart will have the black squares surrounding it, indicating that it is selected. Click anywhere on a white area (Top left corner of the chart is ideal). Hold down your left mouse button and drag the chart downwards into some space.

When you have moved the chart, you need to resize it. Hold down your left mouse button on the centre black square at the bottom. Drag downwards to increase the height of your chart. When you have finished, you should have a pie chart on your spreadsheet like the one below:

If part of your title "Viewing figures in millions" is hidden, you can move it over. Click on your title with your left mouse button. You'll see a border appear around the title:

Click on the shaded border with your left mouse button. Keep your left mouse button held down and drag it to a different position.

And that's it for pie charts. Except we need some of that space that the pie chart is occupying. And the chart is a bit hard to see where it is. It would be better of in a sheet of its own. We can move it.