I discovered Gapminder, and its wonderful Gapminder World Motion Chart:
It is a Flash animation, displaying a HUGE amount of data, and I thought it would be excellent for displaying FHFA House Price Indexes (http://www.fhfa.gov/Default.aspx?Page=87 ).
Previously I made a movie showing US_MSAs Housing Index 1995-1 through 2009-2 (http://www.dennisdixon.net/Quarters1_files/OneSecond.htm); the 1-second-interval is good, but it shows Geography (shape-and-location), and the colors are tied to the Price Index:
These maps do not show either Income Levels (is this
phenomena only affecting High-Income areas?) or Population Levels. The
A Motion Chart can display Price Index movement along the x-axis, MSA Median Family Income along the y-axis, Population (size of the circles), and the color of the circles can be unique (if displaying MSAs within a State) or thematic (a different color for each Region [Nationwide data] or State [Regional data]).
Google has purchased the technology from Gapminder, and has
made it available only through Google Docs. I made a data set for the 22 MSAs
Before playing I recommend you, in the upper-right, change Color to Unique colors (click on totpers), and change Size to totpers (click on Same size). Then click the play button
You can see how the Housing Index jumped out to the far
right, before crashing back to the (current) middle. For more-specific insight,
check the boxes for
This a GREAT tool for Data Exploration, and a lot more fun than this spreadsheet:
Jan 14, 2009: I have made Motion Charts, at the National and Regional levels, of the data for MSAs/MDs/non-MSA areas, and for States, and for Regions.