Football pool pick Life insurance quote Abilify Pain Relief Life Stock Propecia online Viagra uk Consumer credit debt consolidation Spirit air Buy diazepam Car insurance quote Philadelphia Tramadol ultram Super bowl xliii Accutane Insurance rates Allegra Xanax generic blue Credit counseling Airline Superbowl pick Home Best online casino site HeartBurn Relief Debt consolidation company Online black jack game Medical assistants Safety Tramadol hcl Unsecured personal loan Get adipex Best poker software Florida auto insurance 3 in 1 credit report Payday loans Super bowl pool Domain names Airlines Oncology Viagra cialis Cheap acomplia Toyota Best anti virus spyware For Cosmetology Stock the Buy zovirax Medical insurance Online slot Pharmacies Cialis Dentist Spyware free downloads Coupons Day care David Universities Buying viagra online Debt help 

10 x 10 Tips to improve your (Excel) charts: pie charts

by Jorge Camoes on January 15, 2008

I know, I know, no one likes pie charts, but I can’t ignore them. A pie chart compares proportions but it is of limited use: either the data is too complex and a pie chart can’t handle it, or it is too simple and you should just use a table. So, the first tip should be:

  1. Do you really need a pie chart?
  2. Pie charts shouldn’t be compared (comparing market shares in two regions, for example);
  3. Don’t use the “exploded” option;
  4. Five is in general the maximum number of slices you can use in a pie chart, but two is better…;
  5. If there is no other meaningful order, order the slices from maximum to minimum;
  6. Put “other” in a gray slice;
  7. Don’t use a legend, just label the slices;
  8. Use a very small pie chart in a supporting role for a more complex chart;
  9. Use the appropriate color codes to identify groups of slices;
  10. Start the first slice at 0º (noon);

I am sure you can come up with some ideas to make a better pie. Please share your receipt in the comments.

  • Share/Save/Bookmark

{ 1 trackback }

DSA Insights » Blog Archive » Donut Charts!
July 21, 2008 at 13:05

{ 2 comments… read them below or add one }

Jon Peltier January 15, 2008 at 13:18

My faovrite pie is actually a 3D pie, with colored regions stacked vertically. It uses a chocolate cookie crust, with a chocolate pudding layer, then a layer of eggnog pudding, and is topped with an unhealthy amount of whipped cream and garnished with bittersweet chocolate shavings. (”Mmmm, pie…” – Homer Simpson)

Pies do not, however, make a good vehicle for information displays. They are ubiquitous, and we are fooled by their familiarity into thinking that they really show something. A pareto (i.e., sorted column chart) is much more effective at showing comparitive proportions of a whole, particularly if the value axis is scaled to 100% of the whole.

admin January 17, 2008 at 15:00

Sounds delicious…

Once a product manager told me he thought a 3D pie chart looked more precise (I can prove he told me that!). This just shows how far we are from removing pie charts out of sight.

Leave a Comment