Bing in Excel Maps

%3CLINGO-SUB%20id%3D%22lingo-sub-1377159%22%20slang%3D%22en-US%22%3EBing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377159%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20currently%20making%20a%20statistics%20map%20for%20Germany's%20regions%2C%20and%20Excel%20is%20a%20great%20help%20but%20unfortunately%20when%20I%20try%20to%20add%20statistics%20to%20its%20region%20%22Th%C3%BCringen%20%2F%20Thuringia%22%20Bing%20cannot%20find%20it%2C%20and%20therefore%2C%20Excel%20doesn't%20display%20it%20on%20the%20map.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20fix%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1377159%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1377166%22%20slang%3D%22en-US%22%3ERe%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377166%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20experienced%20the%20same%20thing%20recently%20such%20that%20Bing%20Service%20couldn't%20locate%20a%20particular%20region%20when%20creating%20Filled%20Maps.%3CBR%20%2F%3E%3CBR%20%2F%3EJust%20a%20workaround%2C%20in%20that%20cell%20with%20the%20region%20name%2C%20add%20comma%20and%20Germany%20i.e%20Th%C3%BCringen%2C%20Germany.%3CBR%20%2F%3E%3CBR%20%2F%3EThen%2C%20run%20the%20map%20again%2C%20it%20should%20recognize%20that%20region.%20But%20if%20it%20didnt%20recognize%20yet%2C%20then%20you%20have%20to%20send%20Frown%20message%20to%20Microsoft%20from%20File%20%26gt%3B%20Feedback.%20They%20will%20look%20into%20it%20and%20fix%20the%20issue.%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1377458%22%20slang%3D%22en-US%22%3ERe%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377458%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662116%22%20target%3D%22_blank%22%3E%40aekormishin%3C%2FA%3E%26nbsp%3BCouldn't%20replicate%20your%20problem.%20Created%20a%20region%20map%20for%20Germany%2C%20using%20the%20region%20names%20found%20for%20Germany%20by%20the%20geography%20data%20type.%20It%20lists%2016%20regions%20(including%26nbsp%3BThuringia)%20and%20all%20seem%20to%20plot%20on%20the%20map.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1377917%22%20slang%3D%22en-US%22%3ERe%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377917%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20file!%20It%20worked%20just%20fine.%20However%2C%20when%20I%20tried%20to%20follow%20the%20manual%20on%20Office%20365%20support%2C%20there%20was%20an%20advice%20to%20define%20the%20data%20as%20Geographical%2C%20that's%20what%20I%20did.%20In%20attachment%20you%20can%20find%20my%20file.%20Thuringia%20is%20still%20not%20recognised%20by%20Bing%20Map%20in%20there.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1377984%22%20slang%3D%22en-US%22%3ERe%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662116%22%20target%3D%22_blank%22%3E%40aekormishin%3C%2FA%3E%26nbsp%3BI%20see!%20But%20one%20does%20not%20have%20to%20data%20type%20everything%20as%20%22geography%22%2C%20proven%20by%20my%20example.%20Don't%20know%20why%20the%20support%20pages%20insist%20that%20to%20do%20the%20data%20typing%20first.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1377988%22%20slang%3D%22en-US%22%3ERe%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377988%22%20slang%3D%22en-US%22%3EThanks%20anyway!%20You%20saved%20me%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1377996%22%20slang%3D%22en-US%22%3ERe%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377996%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662116%22%20target%3D%22_blank%22%3E%40aekormishin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20better%20not%20to%20complicate%2C%20Map%20Charts%20is%20much%20more%20sensitive%20to%20column%20names%20and%20fulfillment%20of%20data.%20Check%20two%20charts%20at%20the%20bottom%20-%20one%20is%20with%20adding%20the%20country%2C%20another%20not.%20All%20the%20rest%20is%20the%20same%2C%20but%20second%20one%20doesn't%20recognize%20Hamburg.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20for%20Thuringia%2C%20Geography%20data%20types%20recognizes%20it%20only%20as%26nbsp%3BTh%C3%BCringen%20(I%20guess%20that%20is%20correct%20German%20name)%2C%20but%20not%20as%20German%20state%2C%20as%20municipality%20in%20Austria.%20Most%20probably%20the%20issue%20is%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2043419%22%20slang%3D%22de-DE%22%3ESubject%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2043419%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662116%22%20target%3D%22_blank%22%3E%40aekormishin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20problem%20with%20the%20district%20%22Rhein-Erft-Kreis%22.%20Excel%20does%20not%20find%20the%20county%20(even%20in%20other%20notation).%20The%20municipalities%20of%20the%20district%20are%20only%20linked%20to%20the%20administrative%20district%20of%20Cologne.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2043546%22%20slang%3D%22en-US%22%3EBetreff%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2043546%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F922236%22%20target%3D%22_blank%22%3E%40NoStadt%3C%2FA%3E%26nbsp%3BWent%20to%20bing%20Maps%20and%20asked%20for%20driving%20directions%20to%20Rhein-Erft-Kreis.%20In%20a%20location%20picker%2C%20it%20displayed%20the%20name%20Erftkreis%2C%20Bachem.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-01-08%20at%2013.25.32.png%22%20style%3D%22width%3A%20408px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244893iE5BEE8BE526B6F26%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-01-08%20at%2013.25.32.png%22%20alt%3D%22Screenshot%202021-01-08%20at%2013.25.32.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Riny_van_Eekelen_0-1610109099668.png%22%20style%3D%22width%3A%20459px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244894iC99D49C3E34C8927%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Riny_van_Eekelen_0-1610109099668.png%22%20alt%3D%22Riny_van_Eekelen_0-1610109099668.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEntered%20that%20name%20into%20Excel%2C%20data%20typed%20it%20as%20Geography.%20Although%20the%20county%20was%20not%20recognised%2C%20I%20did%20get%20a%20map%20of%20the%20county%20that%20I%20believe%20is%20for%26nbsp%3BRhein-Erft-Kreis.%20Don't%20ask%20me%20why%20or%20how%2C%20but%20this%20just%20proves%20that%20the%20mapping%20function%20is%20far%20from%20perfect%20in%20some%20parts%20of%20the%20world.%20File%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2043873%22%20slang%3D%22en-US%22%3EBetreff%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2043873%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGeography%20tools%20in%20Excel%20don't%20like%20places%20which%20were%20renamed%20in%20previous%2020-30%20years%20and%20quite%20often%20don't%20recognize%20them.%20If%20only%20they%20are%20not%20in%20USA..%3C%2FP%3E%0A%3CP%3EWiki%20says%20that%20in%201975%26nbsp%3B%3CSPAN%3EBergheim%20and%20Cologne%20districts%26nbsp%3Bwere%20merged%20and%20named%20as%26nbsp%3B%3CI%3EErftkreis%2C%26nbsp%3B%20%3C%2FI%3Ein%202003%20it%20was%20renamed%20to%26nbsp%3B%3CI%3ERhein-Erft-Kreis.%3C%2FI%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2044108%22%20slang%3D%22en-US%22%3EBetreff%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044108%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BGreat.%20Hope%20that%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F922236%22%20target%3D%22_blank%22%3E%40NoStadt%3C%2FA%3E%26nbsp%3Bwill%20be%20able%20to%20get%20it%20to%20work.%20As%20said%2C%20it%20just%20proved%20that%20this%20tool%20is%20not%20very%20reliable%20and%20that%20it%20requires%20some%20creativity%20to%20make%20this%20%22feature%22%20work%20properly%20outside%20the%20US.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2097690%22%20slang%3D%22de-DE%22%3ESubject%3A%20Bing%20in%20Excel%20Maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2097690%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%20It%20works%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, 

 

I am currently making a statistics map for Germany's regions, and Excel is a great help but unfortunately when I try to add statistics to its region "Thüringen / Thuringia" Bing cannot find it, and therefore, Excel doesn't display it on the map.

 

Is there any way to fix it?

 

Thanks in advance!

11 Replies
Hello,

I experienced the same thing recently such that Bing Service couldn't locate a particular region when creating Filled Maps.

Just a workaround, in that cell with the region name, add comma and Germany i.e Thüringen, Germany.

Then, run the map again, it should recognize that region. But if it didnt recognize yet, then you have to send Frown message to Microsoft from File > Feedback. They will look into it and fix the issue.

Cheers

@aekormishin Couldn't replicate your problem. Created a region map for Germany, using the region names found for Germany by the geography data type. It lists 16 regions (including Thuringia) and all seem to plot on the map. See attached.

@Riny_van_Eekelen Thanks for the file! It worked just fine. However, when I tried to follow the manual on Office 365 support, there was an advice to define the data as Geographical, that's what I did. In attachment you can find my file. Thuringia is still not recognised by Bing Map in there.

@aekormishin I see! But one does not have to data type everything as "geography", proven by my example. Don't know why the support pages insist that to do the data typing first.

Thanks anyway! You saved me

@aekormishin 

It's better not to complicate, Map Charts is much more sensitive to column names and fulfillment of data. Check two charts at the bottom - one is with adding the country, another not. All the rest is the same, but second one doesn't recognize Hamburg.

 

As for Thuringia, Geography data types recognizes it only as Thüringen (I guess that is correct German name), but not as German state, as municipality in Austria. Most probably the issue is here.

@aekormishin 

Das gleiche Problem habe ich beim Landkreis "Rhein-Erft-Kreis". Excel findet den Landkreis nicht (auch nicht in anderer Schreibweise). Die Gemeinden des Landkreises sind lediglich mit dem Regierungsbezirk Köln verknüpft.

@NoStadt Went to bing Maps and asked for driving directions to Rhein-Erft-Kreis. In a location picker, it displayed the name Erftkreis, Bachem.

Screenshot 2021-01-08 at 13.25.32.png

Riny_van_Eekelen_0-1610109099668.png

 

Entered that name into Excel, data typed it as Geography. Although the county was not recognised, I did get a map of the county that I believe is for Rhein-Erft-Kreis. Don't ask me why or how, but this just proves that the mapping function is far from perfect in some parts of the world. File attached.

 

@Riny_van_Eekelen 

Geography tools in Excel don't like places which were renamed in previous 20-30 years and quite often don't recognize them. If only they are not in USA..

Wiki says that in 1975 Bergheim and Cologne districts were merged and named as Erftkreis,  in 2003 it was renamed to Rhein-Erft-Kreis.

 

@Sergei Baklan Great. Hope that @NoStadt will be able to get it to work. As said, it just proved that this tool is not very reliable and that it requires some creativity to make this "feature" work properly outside the US.

@Riny_van_EekelenIt works thank you!