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%3CLINGO-SUB%20id%3D%22lingo-sub-1816502%22%20slang%3D%22en-US%22%3ERe%3A%20Russia%20map%20chart%20not%20displaying%20properly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1816502%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F845200%22%20target%3D%22_blank%22%3E%40tczifra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20tool%20is%20not%20reliable.%20It's%20quite%20sensitive%20to%20all%20names%20-%20columns%20headers%2C%20names%20of%20places%2C%20order%20of%20records.%20If%20play%20with%20them%20sometimes%20that%20helps.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20checked%20with%20Krasnoyarsk%20Krai%20-%26nbsp%3B%20back%20in%202007%20it%20was%20joined%20with%20Taymyr%20and%20Evenk%20Okrugs.%20But%20chart%20engine%20doesn't%20care%20and%20show%26nbsp%3BKrasnoyarsk%20Krai%20as%20former%26nbsp%3BEvenk%20Okrugs%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20714px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229124iECF06F887AF93055%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EChart%20shows%20it%20together%20with%20Taymyr%20Okrug%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20632px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229129i6F401732BF2CCA0F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ebut%20I%20didn't%20find%20a%20way%20to%20show%20all%203%20together%20(more%20exactly%20one%20relatively%20new%20krai).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20some%20workaround%20could%20be%20found%20for%20other%20places%20if%20you%20have%20time%20to%20play%20with%20them.%20In%20any%20case%2C%20better%20to%20send%20a%20frown%20with%20this%2C%20Microsoft%20follows%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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!

8 Replies

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

I too am experiencing issues with the Russian map where the border disappears if I include data from any other country. it is very easy to replicate with two countries.

motorbikematt_0-1618948751369.png

 
 
 
 
 

It is also easy to replicate when not using the Data Type > Geography. It recognizes all of the names without a problem, but the border around Russia simply disappears.

 

motorbikematt_0-1618948992730.png


I have filed a bug via the Feedback function in Excel.

@motorbikematt 

Did you play with this options or use only Automatic?

image.png

@Sergei Baklan 

 

So it appears that I do not have the same menu options that you do. When I change all the options I have (Map Projection, Map Area) I get the same results.

motorbikematt_0-1618950814171.png

 

@motorbikematt 

These options depend on how data is structured. Could you please share the file with data as on screenshot, I'll try to play then.

@Sergei Baklan 

Thank you very much. If it matters, here is the version that I am using:

motorbikematt_0-1618951439970.png

 

@motorbikematt 

So far I failed. Option appears for some combination of column names, but data is not recognized. Will try some later if find something.

image.png

In general this tool is quite sensitive to column names, do we use table or range, data type or plain text. Never know what's better.

 

To my knowledge Excel version practically doesn't matter, it works on Microsoft server, client only shows the result.

@Sergei Baklan 

Thank you for your help here. I'm noticing some other peculiarities. Take for instance this data:

motorbikematt_0-1618955723649.png

  • The map deletes Russia's border, even though there is no Russian data
  • When viewing Map Area > World, it doesn't render any of the data input from the States (you can barely see the Counties in UK) yet the Count legend in the top right and the associated color shading is spread out in account for data in the States
  • When I delete the 1st two columns (County, Province) the US map lights up immediately

Even if this is user error, this really does amount to a bug.

Is there a resource online that defines the range of column names that can be used? This is all I can find:


Create a Map Chart
https://support.microsoft.com/en-us/office/create-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a3...
Format a Map Chart
https://support.microsoft.com/en-us/office/format-a-map-chart-2c744937-a1cc-48f7-bc5e-776497343a29