When you are presenting the finding of your consulting research you don’t want to show a banal, generic pie chart. Get into the details and show the cause by exploding pie chart sections and showing them as a bar chart. It will help you make the segue from big picture into down-and-dirty detail.
To get the big picture of how a total is distributed, for examples total sales by country or unit volumes by region, most executives want to see a pie chart. This is one of the few things a pie chart might be good for, showing how 100% of a total is distributed. The problem comes in showing details within small segments of a pie chart.
Either you have faced or will face the problem of display a pie chart with a group of small wedges. Someone will always ask, “What is that small purple wedge?” The small details get lost in pie charts.
With Excel 2010 and Excel 2007 we can fix that problem using a “Bar of Pie” chart like the one shown here. Notice that the pie chart shows the relationship of large wedges while a bar chart to the side shows the blow-up of small wedges.
To create a Bar of Pie chart,
To select which pie chart wedges appear in the bar chart,