PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

Waterfall Chart
Box and Whiskers


 

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

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

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

Presidential Demographics

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
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.

Possibly Related Posts:

Bookmark and share this entry:
  • Digg
  • del.icio.us
  • Facebook
  • Technorati
  • TwitThis
  • StumbleUpon
  • Google
  • Reddit
  • MySpace

Comments

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.

Read the PTS Blog Comment Policy.


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





Subscribe without commenting

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