Forum Discussion
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 after Excel recognized the inputs as geographical data.
Any suggestions for how to get a complete and accurate mapchart of Puerto Rico and its counties/municipalities?
Any help is appreciated. Thank you!
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.
5 Replies
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
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 Thank you very much for help with this. I appreciate it very much.
torresco , you are welcome, glad to help
