Forum Discussion

tczifra's avatar
tczifra
Copper Contributor
Oct 25, 2020

Russia map chart not displaying properly

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 Ex...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 20, 2021

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.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 20, 2021

    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.

    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.

    • motorbikematt's avatar
      motorbikematt
      Copper Contributor
      Apr 20, 2021

      SergeiBaklan 

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

      • 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-ec8a358b593b
      Format a Map Chart
      https://support.microsoft.com/en-us/office/format-a-map-chart-2c744937-a1cc-48f7-bc5e-776497343a29

Resources