Excel map chart

Question

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?

Thanks a lot for your help.

sergeibaklan · Answer

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

Both variants are in attached.

sergeibaklan · Answer

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

leoa1875 · Answer

SergeiBaklan&nbsp;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?&nbsp;

sergeibaklan · Answer

LeoA1875&nbsp;
Just in case, you may format it as

leoa1875 · Answer

Oh wow, thanks a lot for your help!

Forum Discussion

Excel map chart

6 Replies

Resources