Chart Map - Japan Regions Not Recognized

New Contributor

Hi,

I am wondering if anyone knows whether Excel Chart Map will recognize Japan Regions?  (eg. Chuba, Kanto, etc.). My Japan Map comes out flat.  Perhaps I am not setting up the column name correctly (Region) or there are abbreviations for the Regions I'm not aware of?

3 Replies

@AmMay1250 

Yes, it's sensitive to column names. You may try like this

image.png

 

@Sergei Baklan Thank you!  This is awesome!  It is a step in the right direction.  I was trying to get it to break down this way if possible (not the colors).  In Japan they are called Regions but unsure 1. Whether Microsoft can do this or 2. If the column is called something else?

@AmMay1250 

That's your choice to show colors or scale, that doesn't matter. Colum names are critical, Map Chart doesn't recognize abstract column names.