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

Poland.xlsx356 KB

Forum Discussion

Can Excel map charts show capital cities of provinces?