Russia map chart not displaying properly

%3CLINGO-SUB%20id%3D%22lingo-sub-1816390%22%20slang%3D%22en-US%22%3ERussia%20map%20chart%20not%20displaying%20properly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816390%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20does%20anyone%20have%20a%20workaround%20for%20this%3F%20I%20made%20a%20map%20chart%20to%20display%20data%20for%20Russia's%20regions.%20Some%20data%20are%20not%20displaying%20properly%20(see%20chart).%20I%20have%20inputted%20data%20for%20all%20regions.%20While%20Excel%20correctly%20recognises%20Krasnoyarsk%20Kray%20(the%20big%20region%20in%20the%20middle%20that%20is%20left%20gray)%2C%20it%20does%20not%20display%20the%20data%20on%20the%20map.%20Moreover%2C%20some%20administrative%20borders%20(e.g.%20the%20border%20that%20cuts%20Kamchatka%20in%20half)%20do%20not%20exist%20any%20more%20and%20while%20Excel%20seems%20to%20know%20that%20(when%20I%20hover%20over%20the%20gray%20part%2C%20it%20displays%20the%20data%20point%20as%20%22Kamchatka%22%2C%20but%20it%20still%20won't%20color%20it%20in%20(and%20since%20that%20territory%20does%20not%20exist%20independently%20any%20more%2C%20there%20is%20nothing%20I%20can%20input%20that%20will%20make%20Excel%20color%20that%20part).%20There%20are%20three%20more%20problematic%20parts%3A%20Ust-Ordinsk%20and%20Aginsk%20(Excel%20recognizes%20them%20as%20part%20of%20the%20region%20surrounding%20them%2C%20but%20won't%20color%20them%20in)%2C%20and%20the%20Komi-Permyak%20District%20which%20it%20does%20not%20recognise%20(as%20it%20should)%20as%20part%20of%20the%20Perm%20Kray.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGrateful%20for%20any%20advice!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1816390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi - does anyone have a workaround for this? I made a map chart to display data for Russia's regions. Some data are not displaying properly (see chart). I have inputted data for all regions. While Excel correctly recognises Krasnoyarsk Kray (the big region in the middle that is left gray), it does not display the data on the map. Moreover, some administrative borders (e.g. the border that cuts Kamchatka in half) do not exist any more and while Excel seems to know that (when I hover over the gray part, it displays the data point as "Kamchatka", but it still won't color it in (and since that territory does not exist independently any more, there is nothing I can input that will make Excel color that part). There are three more problematic parts: Ust-Ordinsk and Aginsk (Excel recognizes them as part of the region surrounding them, but won't color them in), and the Komi-Permyak District which it does not recognise (as it should) as part of the Perm Kray. 

 

Grateful for any advice!

1 Reply
Highlighted

@tczifra 

This tool is not reliable. It's quite sensitive to all names - columns headers, names of places, order of records. If play with them sometimes that helps. 

I checked with Krasnoyarsk Krai -  back in 2007 it was joined with Taymyr and Evenk Okrugs. But chart engine doesn't care and show Krasnoyarsk Krai as former Evenk Okrugs

image.png

Chart shows it together with Taymyr Okrug

image.png

but I didn't find a way to show all 3 together (more exactly one relatively new krai).

 

Perhaps some workaround could be found for other places if you have time to play with them. In any case, better to send a frown with this, Microsoft follows them.