May 09 2020 04:06 PM
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!
May 09 2020 04:23 PM
May 09 2020 10:02 PM
@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.
May 10 2020 06:18 AM
@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.
May 10 2020 07:05 AM
@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.
May 10 2020 07:24 AM
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.
Jan 08 2021 03:42 AM - edited Jan 08 2021 03:43 AM
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.
Jan 08 2021 04:29 AM - edited Jan 08 2021 04:35 AM
@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.
Jan 08 2021 07:29 AM
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.
Jan 08 2021 09:04 AM
@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.