Forum Discussion
Map Chart: Regions not displaying properly
Hi Andrea,
In general, Map Charts is sensitive to column names (better to name them literally as recommended) and it always worth to have Country column (with only "Italy" in your case), otherwise bing engine could recognize Rome as the city in Georgia, USA, not as your capital.
And yes, it's sensitive to non-English names, the only way is play with different transcriptions.
Hi Sergei,
thanks for reply.
it is complicated to explain, I do my best.
I have used all combinations of column names but nothing.
In the end I found this solution: only two columns, one with the Italian name of the English division (Contea (IT) = County (EN)) and the second is the data.
In the rows I have to specify the name of the administrative division in Italian ("Provincia di") and then the name.
Done all this, the map works. However, it is no longer possible to save the sheet due to an unknown error.
I attach screenshot (save does not work ...)
Hi Andrea,
I tried to play with your data (very limited), all combinations of names work, see attached. But i'm on English version.
Not sure what is an issue with saving, try to save without the map and add it once more. And how many rows you have in the table? In my memory there is 100 rows limit, but we have to check.
thank you very much for your help.
Unfortunately adding lines the problem increases.
You can give it a try by selecting a growing number of rows.
The results will always be different.
The method I described above is the only way I've found to display all lines in the map (except those not recognized).
Unfortunately does not save the paper, I think because there are places that do not recognize.
I attach the excel file.
Thanks again,
regards.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.
