Can i create a heatmap of correlation matrix ?

[mboroto_89]

I want to create a heatmap of correlation matrix using the attached, how can i do that?

[RolandSchubert · Accepted solution]

Hi @mboroto_89 ,

you can create a heatmap using the Interactive Chart tool, but you have to reorganize your data a bit. You need to "label" columns and a "value" column for the heatmap, based on your data structure, a Transpose tool should do the job.

In the Interactive Chart tool, you add a layer, select the chart type "Heatmap" and select the label columns for "x" and "y", the value column for "z".

The result will be a heatmap - colors and label can be adjusted according to your needs.

Let me know if it works for you.

Best,

Roland

[mboroto_89 · Accepted solution]

Thanks so much @RolandSchubert your solution works perfectly.