Forum Discussion
Bing in Excel Maps
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
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.
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_EekelenIt works thank you!
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.
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.
- 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
