PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

  Waterfall Chart

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Subscribe

Site search


Recent Posts

Recently Commented

July 2008
S M T W T F S
« Jun   Aug »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Archive


 

Categories


 

Chart Selection Guide

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Chart Rules, As Simple as Possible, But Not Any Simpler!, More Information per Pixel! (the blog of XLCubed, the BonaVista Systems - MicroCharts parent company) has posted some comprehensive chart type selection guidelines, to follow up the recent brouhaha over pie and bar charts. It’s not inappropriate to repurpose a quotation from Einstein, because it reminds us that a data presentation should be simplified to the extent possible, without oversimplifying all meaning out of it.

I am recreating a portion of the XLCubed guidelines here, which shows for a given class of relationship between variables, which chart type you should use.

XLCubed Chart Selection Guidelines

If you want to follow up on the recent posts, here is a roughly chronological list of posts that I’ve followed:

 

Share/Save/Bookmark

Comments

Comment from Colin Banfield
Time: Wednesday, July 16, 2008, 5:54 pm

Jon, excellent guide…and probably represents less than 10% of all charts available in Excel. So many junk charts to filter out…


Comment from Jon Peltier
Time: Wednesday, July 16, 2008, 6:22 pm

It gives me an idea for a charting add-in….


Write a comment





Create Excel dashboards quickly with Plug-N-Play reports.