Home

Unable to create map charts in Excel 2016 for regions and cities

%3CLINGO-SUB%20id%3D%22lingo-sub-210181%22%20slang%3D%22en-US%22%3EUnable%20to%20create%20map%20charts%20in%20Excel%202016%20for%20regions%20and%20cities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210181%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20map%20chart%20for%20Germany%20at%20city%20and%20region%20level.However%20excel%20is%20not%20able%20identify%20different%20cities%20or%20regions%20it%20is%20showing%20only%20one%20data%20point%20for%20entire%20germany.%3C%2FP%3E%3CP%3EPlease%20see%20attached%20xls.What%20i%20want%20is%20different%20regions%2Fcities%20should%20be%20highlighted%20as%20per%20data%20points.%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20do%20this%20or%20it%20is%20a%20%22location%20search%22%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAwaiting%20any%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-210181%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314314%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20create%20map%20charts%20in%20Excel%202016%20for%20regions%20and%20cities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314314%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20a%20way%20to%20map%20city%20data%20in%20Excel%20and%20after%20playing%20around%20with%20this%20for%20hours%20I%20figured%20it%20out%2C%20wrote%20it%20up%20and%20created%20a%20video%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.urtech.ca%2F2019%2F01%2Fsolved-video-easy-way-to-plot-cities-on-a-map-using-excel%2F%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.urtech.ca%2F2019%2F01%2Fsolved-video-easy-way-to-plot-cities-on-a-map-using-excel%2F%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps...%20I%20would%20have%20saved%20me%20a%20pile%20of%20frustration.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-210210%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20create%20map%20charts%20in%20Excel%202016%20for%20regions%20and%20cities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210210%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Shivangi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMap%20Chart%20is%20sensitive%20to%20columns%20name%20(and%20not%20only).%20If%20you%20rename%20your%20Region%20column%20to%20Province%20it%20more%20or%20less%20works%2C%20see%20second%20sheet%20in%20attached.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20it%20doesn't%20work%20on%20cities%20level%3C%2FP%3E%0A%3CP%3E%3CEM%3EMap%20charts%20can%20only%20plot%20high-level%20geographic%20details%2C%20so%20cities%2C%20latitude%20and%20longitudes%2C%20and%20street%20address%20mapping%20isn%E2%80%99t%20supported.%20%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3ESee%20Limitations%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-a-map-chart-f2cfed55-d622-42cd-8ec9-ec8a358b593b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-a-map-chart-f2cfed55-d622-42cd-8ec9-ec8a358b593b%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Shivangi Pandit
Occasional Visitor

Hello All,

 

I have created a map chart for Germany at city and region level.However excel is not able identify different cities or regions it is showing only one data point for entire germany.

Please see attached xls.What i want is different regions/cities should be highlighted as per data points.

Is there any way to do this or it is a "location search" problem?

 

Awaiting any reply.

 

Thanks.

2 Replies

Hi Shivangi,

 

Map Chart is sensitive to columns name (and not only). If you rename your Region column to Province it more or less works, see second sheet in attached.

 

And it doesn't work on cities level

Map charts can only plot high-level geographic details, so cities, latitude and longitudes, and street address mapping isn’t supported.

See Limitations here https://support.office.com/en-us/article/create-a-map-chart-f2cfed55-d622-42cd-8ec9-ec8a358b593b

 

There is a way to map city data in Excel and after playing around with this for hours I figured it out, wrote it up and created a video 

https://www.urtech.ca/2019/01/solved-video-easy-way-to-plot-cities-on-a-map-using-excel/ 

 

I hope this helps... I would have saved me a pile of frustration.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies