Forum Discussion
Chart Maps Missing Country
Spain is recognizable
What's wrong in your concrete case it's hard to say based on part of screenshot without seeing a file. Map charts is quite sensitive to column names, works better with tables rather than ranges, doesn't like if you have different structuring levels in one column (e.g. country and controlled territory) - try to play in this direction.
SergeiBaklan I, too, am having a problem displaying Spain. I've attached my spreadsheet to show you the challenge.
It recognizes it, but only partly, see this small dot
Perhaps the other part is considered as Spain County in South Dakota since you are working with world map.
If help to Excel and name columns as
saying we are working with countries, more of Kingdom of Spain will appear
Please check in attached file.
SergeiBaklan Thank you so much for helping me with that.
SergeiBaklan thank you for your responses. Indeed the map does respond to the name and highlighting the Balearic as well as Tenerife and other islands in the Atlantic, but it refuses to show the mainland.
I do have headers,
tried with and without geography data type
tried with and without table formatting
tried with just Spain
tried different naming and languages
Eventually gave up and moved the data to PowerBI.
I see, but that's hard to discuss without the file. Map Charts is quite specific and sensitive to details, sometimes it's enough to change the order of records. Sometimes nothing helps, but quite seldom.
