Forum Discussion

mkca1n21's avatar
mkca1n21
Copper Contributor
Aug 05, 2022

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...
excel
Excel on Mac
office 365
Patrick2788's avatar
Patrick2788
Silver Contributor
Feb 02, 2023
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.
David_Saputra's avatar
David_Saputra
Copper Contributor
Feb 03, 2023

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.

 

CountryProvinceAverage
IndonesiaBali16.25
IndonesiaBangka Belitung0.0
IndonesiaBanten24.67
IndonesiaBengkulu0.36
IndonesiaAceh2.79
IndonesiaYogyakarta3.51
IndonesiaJakarta1,184.77
IndonesiaGorontalo12.59
IndonesiaJambi1.89
IndonesiaWest Java85.18
IndonesiaCentral Java19.9
IndonesiaEast Java26.74
IndonesiaSouth Kalimantan1.42
IndonesiaCentral Kalimantan0.0
IndonesiaEast Kalimantan25.1
IndonesiaNorth Kalimantan0.09
IndonesiaWest Kalimantan#N/A
IndonesiaRiau Islands0.0
IndonesiaLampung4.55
IndonesiaMaluku3.09
IndonesiaNorth Maluku40.5
IndonesiaWest Nusa Tenggara25.06
IndonesiaEast Nusa Tenggara69.21
IndonesiaPapua21.17
IndonesiaWest Papua3.0
IndonesiaRiau0.65
IndonesiaSouth Australia0.0
IndonesiaWest Sulawesi19.83
IndonesiaSouth Sulawesi8.08
IndonesiaCentral Sulawesi58.71
IndonesiaSouth East Sulawesi15.8
IndonesiaNorth Sulawesi8.35
IndonesiaWest Sumatra3.75
IndonesiaSouth Sumatra2.28
IndonesiaNorth Sumatra10.35

 

 

Resources