Forum Discussion
Solved
Excel Mapchart with missing geographical areas
Hello - I was able to pull-up an Excel mapchart for Puerto Rico showing a lot of its counties/municipalities. However, not all counties are appearing correctly and some aren't showing at all, this af...
I guess that's since municipalities and smaller units have same names. In variant with geography data types Map Charts shows everything, but sometimes smaller unit instead of entire municipality.
If use simple table as the source, the map looks as correct one
Please note Map Charts is quite sensitive to column names. Couple of variants are in attached file.
SergeiBaklan If you change the column title from County to "Province" or "State" then it is a fully working map so that you can do gradients and what not
For some reason Santa Isabel must be written as "Santa Isabel Municipio" but the rest work.
County also works, depends on what exactly we would like to show