Map Chart Europe/Russia

null null
New Contributor

Map Chart Europe/Russia


I am having a problem displaying Europe in my Map Chart. There is a blank space in the European part of Russia. But when I add Russia into my data, the whole Russia would display and I really only want Europe. It would help if I could only display Europe instead of the places with data. But I've not found such option. 

Any advice? 

3 Replies

Re: Map Chart Europe/Russia

Hi null,


Better to post such question to Excel community here, Chart & Visualization space https://techcommunity.microsoft.com/t5/Charts-and-Visualizing-Data/bd-p/Chart_Visual


As for the Map Chart as variant you may add one more column into your table like


and build Map Chart based on it - it will ignore #N/A. Result like this





Re: Map Chart Europe/Russia

That is exactly my problem. I would like to display the small part of Russia in Europe (Kaliningrad Oblast), so it does not seem like there is a sea instead. Any advice?


(And should I repost this question to the place you suggest? I find the classification here quite confusing, sorry) 

Re: Map Chart Europe/Russia



Yes, it's better to repost shortly and give the link on this post. The only reason that's more chances if someone helps you.


As for Kaliningrad Oblast not sure it's solvable. You may try to play with categorization (Country->Province/State/Oblast, don't know how Bing engine recognizes that) and show on map only second level with data (thus for Russia only Kaliningrad Oblast)



Related Conversations
Map Charts with Counties
Dalton Emberton in Excel on
4 Replies
Sharepoint Online and Bing Maps
Arthur Mohr in SharePoint on
12 Replies
Hyperlinks in Bing-Maps or 3D-Maps
Flo diehl in Excel on
0 Replies
Custom Regions in 3D Maps - Bodies of Water
akm_717 in Excel on
0 Replies
Map Chart
Daniel Mollicone in Office 365 on
1 Replies