Jan 06 2018
03:24 AM
- last edited on
Feb 01 2023
11:02 AM
by
TechCommunityAP
Jan 06 2018
03:24 AM
- last edited on
Feb 01 2023
11:02 AM
by
TechCommunityAP
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?
Jan 06 2018 04:48 AM
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
Jan 07 2018 02:10 AM
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)
Jan 07 2018 04:49 PM
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)