Forum Discussion
Excel does not recognize some regencies from a province
Hello! I am working in excel and have to make a map like this about every province in Indonesia. Unfortunately Excel does not reconize every regency, but it's written in the right way. (So he ...
If you select the data in question and click on Data types, Geography, Excel should analyze all of them and tell you which it thinks are ambiguous.
JKPieterse But what can I do so that Excel will recongnize them?
Map Charts is quite sensitive to column names and, of course, place names. I'd add Nort Sumatra as high level; for some regencies add regency into the name (Karo -> Karo regency).
Based on my practice this tool better works with texts, not with structured tables and/or rich data types. In opposite to Microsoft recommendations.
- Well, that worked. Thanks! Can't you do that for every province in Indonesia 😉 haha.
BasTimmers , you are welcome.
Sorry, entire Indonesia takes time. Start yourself and if any concrete questions ask here, someone of us will try to help.
