Director of Visualization at IDV Solutions
Excel Map Hack
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.
Via : @Crid