How to Format Pie Chart segments

From the previous lesson, your Pie Chart segments look like this:

Pie Chart Segements

You can change the color of each slice of your pie chart, and even move a slice. Let's change the colors first.

Change the Color of a Pie Chart Segment

Left click on the pie chart itself to select it:

The Selected Pie Chart

It is selected when you can see those round handles. Now left click on one 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:

An Individual segement is selected

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:

Select Format Data Point from the menu

You should see the following dialogue box appears:

The Format Data Point dialogue box

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

Fill a Data Point

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

Solid Fill Data Point

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

Colour Options

We've gone for a dark orange color, but select any color you like.

Move a Pie Chart Segment in Excel

To move the slice that you've just coloured, click back on Series Options from the options on the left:

Click back on Series Options

Set the Point Explosion slider to about 30%

Point Explosion is set to 30 percent

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

The Finished Excel 2007 Pie Chart

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 look at our third and final chart style - a 2D Line Chart.
 

Create a 2D Line Chart in Excel 2007/2010 -->