SOLVED

Can Excel map charts show capital cities of provinces?

%3CLINGO-SUB%20id%3D%22lingo-sub-1540833%22%20slang%3D%22en-US%22%3ECan%20Excel%20map%20charts%20show%20capital%20cities%20of%20provinces%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1540833%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20map%20chart%20of%20Poland%2C%20with%20various%20data%20at%20a%20provincial%20level.%26nbsp%3B%20However%2C%20it%20would%20be%20much%20easier%20to%20digest%20this%20data%20if%20it%20also%20showed%20the%20capitals%20of%20the%20various%20provinces.%26nbsp%3B%20Ideally%2C%20the%20map%20chart%20would%20only%20show%20cities%20I%20select%2C%20along%20with%20the%20data%20at%20the%20provincial%20level.%26nbsp%3B%20I%20haven't%20figured%20out%20how%20to%20do%20that%2C%20is%20it%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20the%20map%20would%20show%20various%20number%20values%20for%20each%20province%2C%20and%20then%20Warsaw%2C%20Lodz%2C%20and%20Gdansk%20with%20just%20markers%20for%20these%20cities.%26nbsp%3B%20The%20intent%20it%20to%20orient%20the%20consumer%20of%20the%20graph%20with%20the%20general%20geography%20of%20the%20country%2C%20as%20well%20as%20giving%20them%20some%20data%20at%20the%20provincial%20level.%26nbsp%3B%20How%20can%20I%20do%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1540833%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1540921%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20Excel%20map%20charts%20show%20capital%20cities%20of%20provinces%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1540921%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F666135%22%20target%3D%22_blank%22%3E%40figgers3036%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20tried%20to%20play%20with%20that.%20Not%20sure%20everything%20could%20work%2C%20but%20something.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFirst%20point%2C%20Map%20Charts%20is%20quite%20sensitive%20to%20column%20names.%20For%20such%20ones%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20844px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207411i8FA380D622F566E4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eit%20shows%20nothing.%20It's%20enough%20to%20rename%20Region%20to%20Province%20and%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20837px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207412i8B22C5237BCC9D62%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ENow%20rename%20City%20on%20County%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207413i2688F88E08405CA1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ESomething%20like%20this.%20IMHO%2C%20Map%20Charts%20is%20not%20the%20best%20tool%20for%20such%20games.%20Perhaps%20Excel%20Power%20Map%20or%20Power%20BI%20will%20work%20better.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20662px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207414iD9AE163A767CC14D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1540998%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20Excel%20map%20charts%20show%20capital%20cities%20of%20provinces%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1540998%22%20slang%3D%22en-US%22%3E%3CP%3EThanks!%26nbsp%3B%20I%20think%20you're%20right%2C%20I%20think%20another%20program%20would%20be%20a%20better%20option%20for%20this%20specific%20use.%26nbsp%3B%20Thanks%20again%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1541124%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20Excel%20map%20charts%20show%20capital%20cities%20of%20provinces%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1541124%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F666135%22%20target%3D%22_blank%22%3E%40figgers3036%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.  Ideally, the map chart would only show cities I select, along with the data at the provincial level.  I haven't figured out how to do that, is it possible?

 

For example, the map would show various number values for each province, and then Warsaw, Lodz, and Gdansk with just markers for these cities.  The intent it to orient the consumer of the graph with the general geography of the country, as well as giving them some data at the provincial level.  How can I do that?

3 Replies
Best Response confirmed by figgers3036 (New Contributor)
Solution

@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

image.png

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

image.png

Now rename City on County:

image.png

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

image.png

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