Forum Discussion
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 estab...
It 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.
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
