Excel heat map hack

Posted to Maps  |  Tags: ,  |  Nathan Yau

John Nelson from IDV Solutions explains how he uses a Microsoft Excel hack to make geographic cell maps.

While pivoting data in Excel, it occurred to me that I could drag the latitude data into the row and the longitude data into the column. The result would be a 1980’s-Nintendo-looking chunky cell map (which, if I make the cells square, happens to be a pseudo-equirectangular projection). Low and behold.

It’s essentially four quick steps: Round latitude and longitude coordinates, bin them with a pivot table, reverse the order of said table, and color with conditions. You’ve got a rough overview map in a couple of minutes.

And once again, we see Excel provides flexibility to do some stuff. Like Excel paintings. [via @philogb]

Favorites

The Most Unisex Names in US History

Moving on from the most trendy names in US history, let’s look at the most unisex ones. Some names have …

Marrying Age

People get married at various ages, but there are definite trends that vary across demographic groups. What do these trends look like?

Who is Older and Younger than You

Here’s a chart to show you how long you have until you start to feel your age.

Unemployment in America, Mapped Over Time

Watch the regional changes across the country from 1990 to 2016.