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.

figgers3036's avatar
figgers3036
Copper Contributor
Jul 23, 2020

Thanks!  I think you're right, I think another program would be a better option for this specific use.  Thanks again for your help.

Resources