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 does not select those gray boxes) Does anyone have a tip what I can do?
- 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.
