Forum Discussion

figgers3036's avatar
figgers3036
Copper Contributor
Jul 23, 2020
Solved

Can Excel map charts show capital cities of provinces?

I'm trying to create a map chart of Poland, with various data at a provincial level.  However, it would be much easier to digest this data if it also showed the capitals of the various provinces.  Id...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 23, 2020

    figgers3036 

    I tried to play with that. Not sure everything could work, but something.

     

    First point, Map Charts is quite sensitive to column names. For such ones

    it shows nothing. It's enough to rename Region to Province and

    Now rename City on County:

    Something like this. IMHO, Map Charts is not the best tool for such games. Perhaps Excel Power Map or Power BI will work better.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 23, 2020

figgers3036 

I tried to play with that. Not sure everything could work, but something.

 

First point, Map Charts is quite sensitive to column names. For such ones

it shows nothing. It's enough to rename Region to Province and

Now rename City on County:

Something like this. IMHO, Map Charts is not the best tool for such games. Perhaps Excel Power Map or Power BI will work better.

YitHan98's avatar
YitHan98
Copper Contributor
Aug 16, 2022

 

 

SergeiBaklan Hey dude, when I create map chart from the same data from you, the chart legend is different from yours. May I know how you change the legend into different colour instead of same colour?

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 16, 2022

    YitHan98 

    Right click on map, -> Select data from the menu

    Here Edit series (population in this case), and here color by category names

     

    • YitHan98's avatar
      YitHan98
      Copper Contributor
      Aug 17, 2022
      Thanks for the help!

Resources