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.
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.