Forum Discussion
mkca1n21
Aug 05, 2022Copper Contributor
Map graph does not show one of the province
Hello!
I am trying to make a Indonesia map graph in excel with province level data, however one of the newest province (Kalimantan Utara/North Kalimantan) is not shown in graph. This province established in 2012 so it’s not really new. Is there any way for me to be able to show this Kalimantan Utara province in the graph?
Thank you in advance
In Excel, use the Menu Bar and choose Help > Feedback > Report a Problem. Ask Microsoft to update their data.
- Patrick2788Silver ContributorIt might help if you're able to share the data you're using to produce the Map chart. Generally, you'll want to include as much detail as you can when creating Map charts.
- David_SaputraCopper Contributor
The data looks like this (numbers are random or is blank for this sample).
Previously I had the Province first then Country; Having the Country first worked better. But the East Kalimantan problem still persist.
Country Province Average Indonesia Bali 16.25 Indonesia Bangka Belitung 0.0 Indonesia Banten 24.67 Indonesia Bengkulu 0.36 Indonesia Aceh 2.79 Indonesia Yogyakarta 3.51 Indonesia Jakarta 1,184.77 Indonesia Gorontalo 12.59 Indonesia Jambi 1.89 Indonesia West Java 85.18 Indonesia Central Java 19.9 Indonesia East Java 26.74 Indonesia South Kalimantan 1.42 Indonesia Central Kalimantan 0.0 Indonesia East Kalimantan 25.1 Indonesia North Kalimantan 0.09 Indonesia West Kalimantan #N/A Indonesia Riau Islands 0.0 Indonesia Lampung 4.55 Indonesia Maluku 3.09 Indonesia North Maluku 40.5 Indonesia West Nusa Tenggara 25.06 Indonesia East Nusa Tenggara 69.21 Indonesia Papua 21.17 Indonesia West Papua 3.0 Indonesia Riau 0.65 Indonesia South Australia 0.0 Indonesia West Sulawesi 19.83 Indonesia South Sulawesi 8.08 Indonesia Central Sulawesi 58.71 Indonesia South East Sulawesi 15.8 Indonesia North Sulawesi 8.35 Indonesia West Sumatra 3.75 Indonesia South Sumatra 2.28 Indonesia North Sumatra 10.35
- David_SaputraCopper Contributor
Hi. I'm having the same problem. Anyone has a clue on how to get this done? To be precise:
- The map does visually show North Kalimantan & East Kalimantan as separate provinces (also, when it highlights East Kalimantan, it excludes everything else).
- But when we click North Kalimantan, it highlights East Kalimantan instead.
- A mouseover on North Kalimantan shows East Kalimantan's info.
- North Kalimantan is always greyed out despite having a value in the table/data set.
In addition to the above, I also find that I can't use "East Nusa Tenggara" and have to use "Nusa Tenggara Timur" instead for the map to work which means I have to use 2 different languages.
Hope this gets fixed soon.
- AbidCopper Contributor
Hi David,
I have the same issue with yours, have you found the solution for this "North Kalimantan" case ?- David_SaputraCopper Contributor
Hi Abid. Not yet. At the same time, I also find it frustrating that the map isn't updated with the latest changes in Papua where we now have more than just those 2 provinces.