Missing data in Excel maps

%3CLINGO-SUB%20id%3D%22lingo-sub-632775%22%20slang%3D%22en-US%22%3EMissing%20data%20in%20Excel%20maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632775%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%E2%80%99m%20trying%20to%20create%20maps%20over%20Sweden%20using%20municipality%20names.%20It%E2%80%99s%20a%20brilliant%20feature%20and%20the%20maps%20are%20looking%20great%20with%20one%20little%20caveat%20-%20it%E2%80%99s%20missing%20one%20municipality%20which%20results%20in%20one%20area%20in%20Sweden%20being%20labeled%20with%20missing%20data%20(specifically%20it%E2%80%99s%20a%20municipality%20called%20H%C3%A4rn%C3%B6sand).%20I%E2%80%99ve%20tried%20all%20possible%20names%20and%20so%20has%20our%20tech%20support%20to%20no%20avail.%20What%20can%20I%20do%20to%20fix%20this%3F%20Or%20is%20it%20on%20the%20Bing%20Maps%20end%20so%20they%E2%80%99ll%20need%20to%20add%20the%20missing%20municipality%20to%20their%20list%20of%20Swedish%20municipalities%3F%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EGeorg%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-632775%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1303304%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20data%20in%20Excel%20maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1303304%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F346400%22%20target%3D%22_blank%22%3E%40GeorgM%3C%2FA%3E%26nbsp%3BI%20have%20the%20very%20same%20problem%2C%20adding%20also%20a%20communality%20called%20Mark.%20All%20works%20perfect%20with%20the%20exception%20for%20H%C3%A4rn%C3%B6sand%20and%20Mark.%3C%2FP%3E%3CP%3EI%20have%20checked%20GeoNames%20and%20there%20is%20data%20about%20both.%3C%2FP%3E%3CP%3ESo%20why%20are%20they%20missing%20in%20the%20map%3F%3C%2FP%3E%3CP%3EYour%20question%20was%20posted%20almost%20a%20year%20ago.%20No%20feedback%20so%20far%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1305662%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20data%20in%20Excel%20maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1305662%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F619723%22%20target%3D%22_blank%22%3E%40Bertho1944%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%E2%80%99m%20sorry%20to%20say%20that%20I%20never%20got%20a%20reply.%20I%20also%20tried%20to%20get%20the%20organisation%20I'm%20working%20for%20to%20get%20in%20touch%20with%20Microsoft%20but%20that%20hasn't%20led%20anywhere%20either.%26nbsp%3BRegarding%20Marks%20Kommun%2C%20it%E2%80%99s%20a%20case%20of%20possessive%20form%20regarding%20Mark%2C%20it%20should%20in%20other%20words%20say%20Marks%20instead%20of%20Mark.%20This%20however%20does%20solve%20H%C3%A4rn%C3%B6sand.%20I%20ended%20up%20using%20another%20program%20that%20was%20better%20suited%20to%20do%20this%20than%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1305829%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20data%20in%20Excel%20maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1305829%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F346400%22%20target%3D%22_blank%22%3E%40GeorgM%3C%2FA%3E%26nbsp%3BIt%20is%20never%20too%20let%20to%20give%20in%2C%20obviously%20.%20Thanks%20for%20sharing%20your%20experience.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I’m trying to create maps over Sweden using municipality names. It’s a brilliant feature and the maps are looking great with one little caveat - it’s missing one municipality which results in one area in Sweden being labeled with missing data (specifically it’s a municipality called Härnösand). I’ve tried all possible names and so has our tech support to no avail. What can I do to fix this? Or is it on the Bing Maps end so they’ll need to add the missing municipality to their list of Swedish municipalities?

Georg

3 Replies
Highlighted

@GeorgM I have the very same problem, adding also a communality called Mark. All works perfect with the exception for Härnösand and Mark.

I have checked GeoNames and there is data about both.

So why are they missing in the map?

Your question was posted almost a year ago. No feedback so far?

Highlighted

@Bertho1944 

 

I’m sorry to say that I never got a reply. I also tried to get the organisation I'm working for to get in touch with Microsoft but that hasn't led anywhere either. Regarding Marks Kommun, it’s a case of possessive form regarding Mark, it should in other words say Marks instead of Mark. This however does solve Härnösand. I ended up using another program that was better suited to do this than Excel.

Highlighted

@GeorgM It is never too let to give in, obviously . Thanks for sharing your experience.