Back

Questions
About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

BBBOnLine Reliability Seal

Member of the National Speakers Association



 

Excel Pie Chart Secrets


The tip in this show is from Charts and Graphs for Excel 2007.
(Click the book for more details)


Brianna Mcivor, Bill Jelen, and Leo Laporte on the set of The Lab with Leo

Way too many charts rely on the pie chart. In this segment, we will take a look at when you should use a pie chart and when you should not. Also, some cool tricks for sweeter pie charts.

A pie chart should be used to show components that add up to a whole:

Never use a pie to show a time series. Instead, use a column or line chart:

What if you need to show changing pies over time? Switch to a stacked bar chart:

Avoid 3-D Pie charts. Which ever slice is in the front appears much larger. Here, both pies in this image have 30% for Labor, but the lower pie has 107% more dark blue pixels.

Instead, use a 2-D pie, where 30% looks like 30% whether it is at the top or the bottom:

Rather than exploding the entire pie, it is more interesting to explode one slice of the pie. To do this, follow these steps:
  • Create a regular (unexploded) pie chart.
  • Click once on the pie. All wedges are selected.
  • Click again on the desired wedge. Now, only that one data point is selected.
  • Drag that wedge away from the center of the pie.

If you have many tiny slices, the labels tend to overwrite each other. Rotate the pie so that the small slices are in the lower right. There is more room for labels there. To rotate a pie chart:
  • Right-click on the pie and choose Format Series
  • In Excel 2007, the Angle of First Slice slider is first in the Series Options pane. In Excel 2003, click on the Options tab and change the Angle of First Slice.
In the top image, the labels are crowded at the top. In the bottom image, there are more room for the small slice labels:

If you have too many small slices, switch the chart type to a Bar of Pie type chart. Small slices are moved to a secondary chart:

You can control which slices end up in the secondary pie. Right-click the pie and choose Format Data Series. The top options shown here allow you to specify that the secondary pie should be split by percentage, value, or number of items.

Check back in May 2008 and you can view my segment here.

I really hope to give away 5 million copies of the book, so please send your co-workers and friends to leobook.html.

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

 

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.