Forum Discussion
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...
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.
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 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?
Right click on map, -> Select data from the menu
Here Edit series (population in this case), and here color by category names
- Thanks for the help!
Thanks! I think you're right, I think another program would be a better option for this specific use. Thanks again for your help.
figgers3036 , you are welcome
