Bored at work again, so I thought I’d do a little more mapping – only this time, without a GIS.
Who knew you could coax Excel into creating such abominations?
My dataset is the centroids of all* US counties and county equivalents. My apologies to non-USA readers; this set was handy to me because of my work with US census data.
*Except Aleutians West Census Area, which I initially excluded because its centroid is actually in the eastern hemisphere and was messing up the maps. On later maps, I cheated and moved the point ~2° east so it falls within the western hemisphere.
In increasing order of weirdness:
Here’s the entrance to the rabbit hole: A simple Excel scatter plot of the centroids of all US counties and county equivalents. Some interesting patterns are visible here already. Georgia is notable for its many small, compact counties. In the great plains, especially the Texas panhandle, you can see the ranks and files of mostly square counties. See
this county map for reference.
Same as above, but with markers removed and smoothed lines added. (Some pedant on Facebook pointed out to me that this is really just a line graph.) Random colors are pretty! I love how Alaska and Hawaii are rendered.
As above, but this time I made four data series in an attempt to do a 4-color map. But due to the vertical scribbling, some states were obscured. Solution: Use more colors.
Much better! I’ve also re-added Aleutians West Census Area (by cheating). It required seven different colors.
Same as above, just using brighter colors. Georgia really pops out with its dense scribble.
Amazingly, you can still see the shapes of the states.
Now things got really bizarre:
Same data, now plotted on a “radar” chart. Latitude is radial, with the equator represented by the single center point marked “0”. The north pole is a ring, but outside the edges of the chart. The X axis of a radar chart is categorical, not linear, so all the points are spread out around the full circle. I’ve highlighted a few points of interest.
A couple of changes here. First, latitudes were subtracted from 90° to make the map “right side up”. So now the north pole is in the center (actually 70°N, shown as “20”). Then, in order to fake 360° of longitude, I created “dummy” counties, spaced every 0.1° around the equator. You can see two arcs of the equatorial counties on the left. I also rounded all longitudes to 0.1°.
This is by far the weirdest “map” I’ve ever made. I’d like to try these techniques with the whole world, although Excel would probably choke on it.