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

Marrying Age

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

How We Spend Our Money, a Breakdown

We know spending changes when you have more money. Here’s by how much.

Pizza Place Geography

Most of the major pizza chains are within a 5-mile radius of where I live, so I have my pick, …

Real Chart Rules to Follow

There are rules—usually for specific chart types meant to be read in a specific way—that you shouldn’t break. When they are, everyone loses. This is that small handful.