Forum Discussion
Excel Map Not Showing all Provinces for Saudi Arabia
I have tried mapping some basic data at regional level for Saudi Arabia. Country has 13 regions and event though excel identifies correctly each one of the regions in the Geographic Data format it fails to display data on the map for two regions namely: Al_Qassim and Ha'il Regions.
I saw some earlier pots on similar problems for Germany or Spain, and tried various alternatives but was not able to solve the problem.
any suggestion would be appreciated
It works if remove geography data types, play with column names and country/province names
Artificial intelligence is not very straightforward thing.
11 Replies
kce_powerten can you please explain how did you create this type of excel. i am not sure to understand it. is it power query? how did you link the data to bing.com ?
give me hints to google it or youtube it plz.
That is Map Charts available for Office365 subscribers and Excel 2019 https://support.microsoft.com/en-us/office/create-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a358b593b
It works if remove geography data types, play with column names and country/province names
Artificial intelligence is not very straightforward thing.
Dear Sir,
Please let me know how i will split the map of Eastern province of Saudi Arabia.
Like : Dammam, Al Khobar, Jubail etc SergeiBaklan
Afraid no way. Tool works not very good with geography outside USA, especially on third level (county of Eastern Region of Saudi Arabia).
In any case it will show you entire country, an option is to show only regions with data. And it's quite sensitive to the names. You may try to play with them. Unfortunately I'm not familiar with Saudi Arabia geography, but what I see each district has 3-5 (at least) different variants of the name in English. You may use Arabic names as well.
Please check in attached how it could be. Sorry to say, I'm suspicious if tool works for such case.
- Same problem for egypt provinces can you help
SergeiBaklan - Here attached is my problem file - can you help me to correct it please?
Regards
Andrew
