I have hierarchical data on market sectors at five levels of granularity. I have shown this as nested- data in the past (level 3 grouped by level 2 and by level 1) using other software packages, with the heat map squares and colours reflecting the size of a specific value.

Try as I may, I cannot create any heat map in Zoho despite using all of the combinations of data on the x and y axes that I can think of. Neither could I find any examples online to instruct me.

Is there an idiot's guide somewhere that I have missed?

Thanks

Martyn