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.

Presidential Demographics

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

In Presidential Demographics, Part II, Robert Kosara has posted a very nice interactive infographic that allows you to answer a host of questions about US presidents:

Would McCain be the oldest US President? Would Obama be the youngest? Who was the youngest president? Were presidents younger in the past or older? What is the highest number of years a former president lived after leaving office? Who served the longest? Whose term was the shortest?

The chart lets you view presidents lifetimes and terms in office on a regular timeline, aligned by birth, or aligned by start of time in office. When you mouse over a bar, a pop-up displays the president’s name, date of birth and death, and dates in office. Here are a few screenshots.

EagerEyes Presidential Demographics Timeline

EagerEyes Presidential Demographics By Birth

EagerEyes Presidential Demographics By Ascension

I found this graphic very interesting, and I even learned a couple things. For example, I knew JFK was the youngest president ever to take office, until this chart showed me that Teddy Roosevelt actually held this honor. If I get ambitious, I may try to replicate this graphic in Excel.

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 Robert Kosara
Time: Sunday, August 24, 2008, 3:05 pm

I’m glad you like it! I actually prototyped this in the OpenOffice spreadsheet when I first collected the data some time ago. It’s fairly easy to produce these three graphs with a few additional columns and stacked bar charts. I can send you the file, if you are interested. I’m also going to post the Java source code including the data file (which only contains name, date of birth, death, ascension, and end of term in a simple CSV file) soon.

The reason for making it interactive was to make it easier to compare, especially length of term and ascension age. Plus, it’s more engaging and fun, so people might be compelled to spend more time with it.


Comment from Jon Peltier
Time: Sunday, August 24, 2008, 5:12 pm

Robert -

The interactivity, both in highlighting a particular president and in changing the view, is what makes the chart interesting.

I would like to get my hands on the data (I had visions of mousing over each president, and entering the data into a worksheet).


Comment from tim
Time: Sunday, August 24, 2008, 7:33 pm

I like it because it has to deal with the anomaly of the non-consecutive term.


Comment from Jon Peltier
Time: Sunday, August 24, 2008, 8:47 pm

Tim – I like that too. I’ve thought of a couple other ways to deal with it, but I suspect neither is any better than Robert’s.

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.