Dona Barbara

Microsoft Excel 2007 to 2010
How to Create a Pie Chart in Excel
Pie charts are quite easy to create in Excel 2007 and Excel 2010. In case you're not sure what a Pie Chart is, here's the basic one you'll be creating. Later, you'll add some formatting to this:

To make a start, you need to highlight some data. Create the following simple spreadsheet. The cells to use are D4 to E14:

*Highlight the cells D4 to E14
* Click the Insert menu at the top of Excel
* Locate the Chart panel, and the Pie item:

Click the down arrow and select the first Pie chart:

* A new Pie chart is inserted
* Move your new pie chart by dragging it to a new location
* Notice how all the segments of the pie chart are the same colour in Excel 2007:

To get different colours,make sure that your chart is selected and locate the Chart Style panel:

Click the down arrow to the right of the Chart Style panel to reveal the available styles :

We've gone for the second one, Style two. The chart will then look like this:

 
It looks pretty good for just a few mouse clicks! We can still do a bit more to it, though. In the next part, you'll see how to add the viewingfigures to the pie chart segments.
 Add Data Labels to a Pie Chart
In the previous tutorial, you created an Excel Pie Chart that looks like this:

 
 
At the moment, though, there's no information about what each segment represents. We're going to add the numbers from our ITV viewing figures. These ones:

To add the numbers from our E column (the viewing figures), left click on the pie chartitself to select it:

The chart is selected when you can see all those blue circles surrounding it. Now right click the chart. You should get the following menu:

From the menu, select Add Data Labels. New data labels will then appear on your chart:

The values are in percentages in Excel 2007, however. To change this, right click your chart again. From the menu, select Format Data Labels:When you click Format Data Labels , you should get a dialogue box. This one:

If there's a tick in Percentage, untick this and select Value:

Your chart will then have the correct numbers:

Overall, the chart looks OK. But we can add some formatting to it. in the next part, you'll see how to format each individual segement of the Pie Chart. We'll change the colour of one segement, andseparate it.
How to Format Pie Chart segments
From the previous lesson, your Pie Chart segements look like this:

You can change the colour of each slice of your pie chart, and even move a slice. Let's change the colours first.
 
Change the Colour of a Pie Chart Segement
Left click on the pie chart itself to select it:

It is selected when you can see those round handles. Now left click onone of the segments to select just that individual slice. It's a little bit tricky, but if you do it right your pie chart should look like this:

In the image above, only the 10.99 segment is selected. You should see round circles surrounding just that segment. Now right click your segment and, from the menu that appears, select Format Data Point:

You should see the following dialogue boxappears:

Click on Fill from the options on the left. The dialogue box changes to this:

There are quite a lot of options to experiment with. But select the Solid Fill option:

Now click the colour picker, and choose a new colour for the segment:

We've gone for a dark orange colour, but select any colour you like.
 
Move a Pie Chart Segement in Excel
To move the slice that you've justcoloured, click back on Series Options from the options on the left:

Set the Point Explosion slider to about 30%

Now click the Close button. Your chart should look something like this one:

Change the rest of the slices in exactly the same way. You can format the rest of the chart exactly like you did for the Bar chart. But it looks quite impressive as it is!
 
In the next part, we'll...