Creating maps in Excel pivot tables

When I can't be bothered doing something because it's too much hassle, I like to find a work around and data analysis is no different. When I was looking to plot fire brigage data onto a map, I faced having to convert 23,000 coordinates from the Ordnance Survey National Grid into the cartographic map projection used by google maps if I would be able to plot them without buying some fancy pants GIS software. Using my knowledge of MS Excel, I was able to achieve exactly what I wanted to in less than five minutes.
Read more »
 

Popular Posts