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…

This map of historic tornado hot spots is really just an Excel pivot table. Read on to see how to spatial-hack Excel in this devious way.