Forum Discussion
BasTimmers
Jan 30, 2024Copper Contributor
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 ...
BasTimmers
Jan 31, 2024Copper Contributor
JKPieterse But what can I do so that Excel will recongnize them?
SergeiBaklan
Jan 31, 2024Diamond Contributor
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.
- BasTimmersJan 31, 2024Copper ContributorWell, that worked. Thanks! Can't you do that for every province in Indonesia 😉 haha.
- SergeiBaklanFeb 01, 2024Diamond Contributor
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.
- BasTimmersFeb 27, 2024Copper ContributorHello! It has worked for every province except Papau province. Could you help me with this? It doesn't recognize quite a few regencies.