SOLVED

Maps in Colombia, La Guajira

%3CLINGO-SUB%20id%3D%22lingo-sub-1505754%22%20slang%3D%22en-US%22%3EMaps%20in%20Colombia%2C%20La%20Guajira%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505754%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Community.%3C%2FP%3E%3CP%3EI%20have%20the%20current%20problem%20with%20Excel%20Maps%2C%20in%20Colombia%20%22La%20Guajira%22%20is%20like%20a%20state%20and%20have%20Counties%20also%2C%20but%20some%20of%20them%20are%20identifiable%20and%20others%20don't.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20ones%20Bing%20maps%20can%20show%20then%20are%20in%20blue%20and%20the%20others%20are%20in%20gray.%3C%2FP%3E%3CP%3EMy%20question%20is%20the%20following%2C%20There%20is%20some%20functions%20or%20some%20data%20from%20Bing%20or%20Excel%20to%20identify%20those%20gray%20areas.%3C%2FP%3E%3CP%3EThank%20you%20so%20much.%3C%2FP%3E%3CP%3ELink%20for%20the%20file.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdrive.google.com%2Fdrive%2Ffolders%2F1z63hERikAlb1DDlCoKIJ-4xymHCWgurS%3Fusp%3Dsharing%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fdrive.google.com%2Fdrive%2Ffolders%2F1z63hERikAlb1DDlCoKIJ-4xymHCWgurS%3Fusp%3Dsharing%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ProblemLAGUAJIRA.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203743i97DD26CBB8C91A00%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22ProblemLAGUAJIRA.png%22%20alt%3D%22ProblemLAGUAJIRA.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1505754%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1508813%22%20slang%3D%22en-US%22%3ERe%3A%20Maps%20in%20Colombia%2C%20La%20Guajira%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1508813%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EThank%20you%20so%20much.%20This%20helps%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1506080%22%20slang%3D%22en-US%22%3ERe%3A%20Maps%20in%20Colombia%2C%20La%20Guajira%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506080%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F720362%22%20target%3D%22_blank%22%3E%40JulianCastillo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMap%20Charts%20is%20quite%20sensitive%20to%20columns%20names.%20If%20rename%20a%20bit%20(in%20English%2C%20but%20you%20may%20try%20in%20Spanish)%20result%20is%20bit%20better.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F203834i2A811D9FDED8C46C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Community.

I have the current problem with Excel Maps, in Colombia "La Guajira" is like a state and have Counties also, but some of them are identifiable and others don't. 

The ones Bing maps can show then are in blue and the others are in gray.

My question is the following, There is some functions or some data from Bing or Excel to identify those gray areas.

Thank you so much.

Link for the file.

https://drive.google.com/drive/folders/1z63hERikAlb1DDlCoKIJ-4xymHCWgurS?usp=sharing

 

ProblemLAGUAJIRA.png

3 Replies
best response confirmed by JulianCastillo (New Contributor)
Solution

@JulianCastillo 

Map Charts is quite sensitive to columns names. If rename a bit (in English, but you may try in Spanish) result is bit better. 

image.png

 

@Sergei BaklanThank you so much. This helps a lot.

@JulianCastillo 

You are welcome, glad to help