Peltier Tech Blog

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Add-Ins

Peltier Tech Waterfall Chart Utility
Peltier Tech Cluster-Stack Chart Utility
Peltier Tech Box and Whisker Chart Utility
Peltier Tech Marimekko Chart Utility
Peltier Tech Dot Plot Utility
Peltier Tech Cascade Chart Utility

 
Excel Dashboards

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Chart Selection Guide

by Jon Peltier
Monday, July 14th, 2008
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

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:

 

Related Posts:

Bookmark and share this entry:
  • Twitter
  • Digg
  • Facebook
  • LinkedIn
  • del.icio.us
  • Technorati
  • StumbleUpon
  • Google Bookmarks
  • Reddit
  • MySpace
  • Slashdot
  • Yahoo! Buzz
  • Tumblr

Learn how to create Excel dashboards.

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

I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.

If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Read the PTS Blog Comment Policy.





Subscribe without commenting

Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

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