Problems with heat maps

%3CLINGO-SUB%20id%3D%22lingo-sub-2416573%22%20slang%3D%22en-US%22%3EProblems%20with%20heat%20maps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416573%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3EI%C2%B4m%20trying%20the%20create%20a%20heat%20map%20of%20Ecuador%20and%20it%C2%B4s%20provinces%3B%20but%20some%20of%20them%20are%20not%20being%20recognized.%20Can%20someone%20tell%20me%2C%20where%20can%20I%20find%20the%20geopolitical%20division%2C%20in%20which%20Excel%20bases%20on%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20advanced.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2416573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello all,

I´m trying the create a heat map of Ecuador and it´s provinces; but some of them are not being recognized. Can someone tell me, where can I find the geopolitical division, in which Excel bases on?

 

Thank you advanced. 

1 Reply

@CrisSantax 

It very sensitive to source data organization - do you use range or table, data types or plain text, what are column names. In general it works:

image.png