Map Help in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2611207%22%20slang%3D%22en-US%22%3EMap%20Help%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2611207%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20map%20in%20Excel.%20I%20have%20changed%20my%20data%20type%20to%20Geographic%3B%20however%2C%20the%20map%20doesn't%20present%20any%20data.%20ny%20help%2C%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2611207%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2612134%22%20slang%3D%22en-US%22%3ERe%3A%20Map%20Help%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2612134%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1120455%22%20target%3D%22_blank%22%3E%40Maysam1140%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20tool%20is%20not%20the%20map%20itself%2C%20it%20only%20allows%20to%20show%20some%20values%20on%20the%20map.%20If%20you%20have%20no%20such%20data%20it's%20nothing%20to%20show.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I am trying to create a map in Excel. I have changed my data type to Geographic; however, the map doesn't present any data. ny help, please?

3 Replies

@Maysam1140 

The tool is not the map itself, it only allows to show some values on the map. If you have no such data it's nothing to show.

Thank you for your answer. I am creating a map for my data. It gives me a message that 5% of data is presented with confidence!

@Maysam1140 

Map Charts is quite sensitive to column names, data organization (range, tables, linked data types) and, of course, name of places themselves. If you build map for the cities (minimum level with which the tool work) it could help if you add state or country column, even if all cities are in same state.

 

For more concrete discussion it's better to have sample file.