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.
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
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
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.