Forum Discussion
Map Chart: Regions not displaying properly
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.
Find attached a working map of Italian provinces - couple of workarounds are needed (Mantova, Ravenna)
- 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,