I watched Hans Rosling's
inspiring presentation at TED and HAD to apply at least some of what he did to some data I was playing with that day. I was looking at patterns of voter registration data in Presidential years in New Hampshire. There were four variables that I was playing with: geography, three types of party registration (Democrat, Republican, Independent), number of registered voters and time. I didn't have a good way to show this until Hans' talk inspired me.
I didn't have the sophisticated software that he has, and I like the challenge of doing fun things with the basics. With Excel and PowerPoint you can do almost anything! So I came up with an animated PowerPoint showing the New Hampshire counties moving in 'party registration' space. Here's a still of the end of the animation:

You'll see that some are bigger than others, since there is a different number of registered voters in each. This still is 2004 and you can see the dotted trails that trace out the path that the counties took to get to their 2004 position from their 1992 position.
The general trend is that they moved to the left (less democratic) in 1996, down and to the left in 2000 (more independent) and then slightly to the right in 2004 (more democratic). The relative lengths and angles of the lines tell you about the relative differences in how party registration varied in those towns.
Within each county, there are multiple towns. Not all of which behave the same. So I created another type of chart and an animation to show this. Here is a still from 2004:

Each county has a colour, and the sum of the sizes of the blobs shows you the number of registered voters. The spread on the x axis shows the variation in the percent of voters that are registered either Democrat or Independent in the various towns in each county. Note that a big blob could be a big town, or the sum of many small towns.
Here's a link to the
animated PowerPoint presentation itself.
Add a comment