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

%3CLINGO-SUB%20id%3D%22lingo-sub-934928%22%20slang%3D%22en-US%22%3ECan%20I%20map%20data%20onto%20a%20digital%20map%20of%20an%20area%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-934928%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20some%20advice%2C%20I%20am%20doing%20a%20project%20at%20work%20where%20we%20use%20customer%20postcodes%20and%20map%20their%20locations.%20So%20far%20I%20have%20managed%20to%20make%20a%20core%20datasheet%20listing%20all%20postcodes%20in%20the%20area%20and%20then%20further%20town%20tabs%20with%20small%20tables%20which%20count%20the%20data%20per%20postcode.%20I%20have%20added%20images%20of%20the%20town%20maps%20with%20hand-drawn%20boundaries%20to%20let%20us%20see%20where%20the%20biggest%20concentrations%20of%20customers%20are%20coming%20from.%20I%20am%20just%20learning%20Excel%20and%20it's%20capabilities%20and%20admit%20this%20spreadsheet%20more%20complicated%20formulas%20(H%20Lookup)%20are%20based%20on%20someone%20else's%20spreadsheet.%20Is%20it%20possible%20to%20use%20the%20data%20to%20add%20a%20'dot'%20on%20the%20image%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20using%20Office%202010%20but%20will%20shortly%20be%20moving%20onto%20Office%202016.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-934928%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMaps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Epostcode%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-946726%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20map%20data%20onto%20a%20digital%20map%20of%20an%20area%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-946726%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F139501%22%20target%3D%22_blank%22%3E%40Gemma%20Telfer%3C%2FA%3E%26nbsp%3BTake%20a%20look%20at%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FGet-started-with-Power-Map-88A28DF6-8258-40AA-B5CC-577873FB0F4A%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EPower%20Map%3C%2FA%3E.%20It%20will%20let%20you%20plot%20individual%20addresses%2C%20and%20even%20indicate%20values.%20In%20Excel%202016%2C%20you'll%20need%20to%20go%20to%20File%20%26gt%3B%20Options%20%26gt%3B%20Add-ins%20%26gt%3B%20Manage%20%26gt%3B%20COM%20add-ins%20%26gt%3B%20Check%20the%20Power%20Map%20option%20to%20enable%20the%20feature.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHTH%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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