Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

Formatting Pie Charts and Using Bar-of-Pie and Pie-of-Pie Charts

If you create a pie chart in Excel you can format it to make certain items stand out.  One of the best ways to do this is to remove a slice of the pie chart.  The chart below shows the monthly rainfall for 2000.

If we click on the chart, handles appear around the circumference of the pie.  A further single click on one section of the pie selects that section and it can then be dragged out to emphasise it.  Dragging while the whole pie is selected will ‘explode’ the pie chart, separating all the segments.  The chart below has a removed segment.

 

Sometimes pie charts can be a problem when some of the segments are so small that they are hardly readable.  This problem can be solved by using a bar-of-pie or pie-of-pie chart.  Consider the following data: 

2000

880.00

2001

647.00

2002

1060.00

Jan

29.30

Feb

79.00

Mar

28.20

Apr

105.60

May

45.20

Jun

51.50

Jul

13.40

Aug

110.60

Sep

89.60

Oct

109.10

Nov

102.10

Dec

116.50

  This shows the total rainfall for the years 2000 to 2002 but the 2003 data is split into months.  If we highlight all these cells we can click on the Chart Wizard icon and create a bar-of-pie or pie-of-pie chart as shown below.

We can then work through the Chart Wizard, choosing to put labels on each section of our pie chart to help us arrange it later.  Here is the resulting chart.

 

The ‘Other’ section is the sum of the sections shown on the bar.  Unfortunately, the bar is missing the months from January to July.  We can rectify this by clicking and dragging those segments out of the pie chart onto the bar in the same way as we would when removing the segments from the pie chart for emphasis.  If you find it difficult to grab a very thin segment, select the whole pie and drag it out to separate all the segments then move the thin segment over to the bar, select the whole pie again and drag the segments back to the centre to join them up again. 

The last step is to change the ‘Other’ label to show ‘2003’.  Simply double-click on that label and change it to read 2003.

Click here to return to the Excel index.