Excel Maps - problem with Western Sahara and Morocco

%3CLINGO-SUB%20id%3D%22lingo-sub-2316754%22%20slang%3D%22en-US%22%3EExcel%20Maps%20-%20problem%20with%20Western%20Sahara%20and%20Morocco%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2316754%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20create%20a%20map%20in%20excel%20with%20data%20concerning%20Morocco%2C%20the%20map%20automatically%20selects%20the%20Western%20Sahara%20together%20with%20Morocco%20(see%20attched%20screenshot).%20How%20can%20I%20avoid%20this%3F%20I%20want%20to%20be%20able%20to%20see%20at%20least%20the%20dashed%20line%20between%20this%20two%20areas.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGiulia%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2316754%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi

 

When I create a map in excel with data concerning Morocco, the map automatically selects the Western Sahara together with Morocco (see attched screenshot). How can I avoid this? I want to be able to see at least the dashed line between this two areas. 

 

Thank you for your help.

 

Giulia

1 Reply

@Gperi8 

Chart Maps is sensitive to column names, as well as do you use tables, ranges and data types. Perhaps different variants for the place name.

That's only to play with all above without warranty for the success, no strict rules here.