Excel map chart

Copper Contributor

When using Excel map charts for the Central African Republic, Excel does not recognize all areas (even if it knows the area. Accordingly, Haut-Mbomou is marked as an area but on the map, no data are visible (See attached the grey area). Does anyone know how o solve this problem?

 

LeoA1875_1-1682690409374.pngLeoA1875_2-1682690419549.png

 

Thanks a lot for your help.

6 Replies

@LeoA1875 

Try to play with spelling, wording and column names, tools is quite sensitive to above. Plus usually it's better to use text data.

image.png

@SergeiBaklan 

Thanks for the quick reply. I have already tried and tried again, but the data for Haut-Mbomou is still not visualised. Is there any way to add this data analogously? 

@LeoA1875 

It's not shown for me if only I use Data Type instead of plain text

image.png

Both variants are in attached.

@LeoA1875 

Just in case, you may format it as

image.png

Oh wow, thanks a lot for your help!

@LeoA1875 , you are welcome