Oct 23 2019 06:02 AM
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.
Oct 24 2019 12:24 PM
@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