Forum Discussion

Copper Contributor

Jan 06, 2018

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

excel

office 365

SergeiBaklan

Diamond Contributor

Jan 06, 2018

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

null null

Copper Contributor

Jan 07, 2018

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)

SergeiBaklan
Diamond Contributor
Jan 08, 2018
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)