Forum Discussion
Map Chart: Regions not displaying properly
I have a similar problem.
I'm trying to create a map of Italy to second-order administrative division.
I added columns (first and second administrative division), I've changed names and the results are always different: sometimes displays the world (??), sometimes just a line, sometimes only a country without breakdowns, sometimes a State. Any attempt graph worsens.
there is a way to refine the search?
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.
SergeiBaklan I have a similar error (sometimes displaying the country regions correctly sometimes the whole world) with Portugal despite the fact that the country is identified correctly.
After testing it I notices that the Faro district is causing the problem. For some reason when I add any municipality of the Faro district excel/bing switches from the Portugal map to the World Map. If I zoom in Portugal I can see that the Faro District is filled in with the right colours (so it is recognizing it as being in Portugal) but Portugal being so tiny relative to the world, zooming in gives an ultra pixelized map with poor definition (unusable).
Seems like a bug. Is there a fix?
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.
