Forum Discussion
Map Chart: Regions not displaying properly
Yes, looks strange.
Sorry, i'm not strong in the georgaphy of Italy, just played on limited list. If change some names, for examle Brescia on Bresciano it shows the province correctly. Moreover, if after that return back Bresciano on Brescia it continues to show it correctly. Same with Verbano and Verbania.
Will think bit more about this tomorrow, it's time to finish for today.
Hi Andrea,
I played bit more with your file, afraid this tool is not for your purposes
1) It's quite sensitive to the names of geographical areas, they shall be spelled in the way bing understands. But that's minor issue - see second sheet in attached file, names are downloaded from wiki and are recognizable bit better
2) Engine doesn't recognize if the place is Metropolian City, not province (e.g. Palermo). In some cases it helps if you rename as Province of Palermo, but that doesn't work, for example for Latina and Messina. I have no idea how to make them recognizable. By the way, bing maps shows two latest somewhere in the sea, perhaps that's the reason why Maps Charts doesn't recognize them within the Italy.
3) And the real showstopper the tool doesn't work with relatively big amount of data as in your case. You may create the chart, and even save the file, but after you try to do any modification with the chart it prevents you to save the file again. The only way is to remove the chart, save file without it, open it again and re-create the chart.
Perhaps Microsoft support knows more about the limitations, i saw nothing.
The workaround could be using 3D maps if you want to stay in Excel environment. Or wait till Maps Chart will be improved.
- MIke_K1280Feb 27, 2019Copper Contributor
Hi - I am having the same issue with some very simple data and cannot seem to figure it out. I have attached it. Just trying to get the counties in the state of Massachusetts to display correctly. Any help is appreciated.
- Frederic OGUERJun 27, 2017Copper Contributor
Hi,
I have the same problem with France.
I t's working with column "county" (EN) or "contea" (IT) for "Département"(FR) (2nd administrative division).
I try with "Comté" (FR) but it doesn't work.
I can put the number of the department (not only the name).
What is the correct transcription of the second administrative division in French ?
Best regards,
- gianluca angeliciJun 21, 2017Copper Contributor
Find attached a working map of Italian provinces - couple of workarounds are needed (Mantova, Ravenna)