Map Chart Europe/Russia

New Contributor

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

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

 

 

 

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) 

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