Home

Map Chart Europe/Russia

Highlighted
null null
New Contributor

Map Chart Europe/Russia

Hi, 

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

=IF([@Country]="Russia",NA(),[@Country])

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

MapChartNoRussia.JPG

 

 

 

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

Hi,

 

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)

RegionsWithData.JPG

 

Related Conversations
Map Chart
Daniel Mollicone in Office 365 on
1 Replies
Sharepoint Online and Bing Maps
Arthur Mohr in SharePoint on
9 Replies
Map
Adrianna Smith in Excel on
1 Replies