Problems with heat maps

Occasional Visitor

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


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: