Map graph does not show one of the province

[mkca1n21]

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

[#2]

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.

[#3]

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.

[#4]

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