Can I map data onto a digital map of an area?

Copper Contributor

Hi All

 

I am looking for some advice, I am doing a project at work where we use customer postcodes and map their locations. So far I have managed to make a core datasheet listing all postcodes in the area and then further town tabs with small tables which count the data per postcode. I have added images of the town maps with hand-drawn boundaries to let us see where the biggest concentrations of customers are coming from. I am just learning Excel and it's capabilities and admit this spreadsheet more complicated formulas (H Lookup) are based on someone else's spreadsheet. Is it possible to use the data to add a 'dot' on the image? 

 

Currently using Office 2010 but will shortly be moving onto Office 2016.

1 Reply

@Gemma Telfer Take a look at Power Map. It will let you plot individual addresses, and even indicate values. In Excel 2016, you'll need to go to File > Options > Add-ins > Manage > COM add-ins > Check the Power Map option to enable the feature.

 

HTH