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 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.

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    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

      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

       

       

  • David_Saputra's avatar
    David_Saputra
    Copper 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.

    • Abid's avatar
      Abid
      Copper Contributor

      Hi David,
      I have the same issue with yours, have you found the solution for this "North Kalimantan" case ?

      • David_Saputra's avatar
        David_Saputra
        Copper 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.

Resources