I was puttering around on the internet when I came across Daniel Ferry’s old post on Location mapping in Excel. The idea is that you can use latitudes and longitudes to plot points on a chart. Cool trick.
Then I wondered if you could achieve a similar result with a PivotTable. Well…it turns out you can.
This is a screenshot of a map visualization I pulled together using a normal a PivotTable.
With slicers, this PivotTable becomes a dynamic location intelligence component for your dashboards.
The steps to create this kind of map are pretty straight forward: Read more