Heat Map

Hi All

I have posted in another section but realised this was incorrect and will delete that post.

Basically I have a simple table which shows risk name, impact and probability. Impact and probability are both on a scale of 1 to 5 with the total being impact * Probability giving minimum score of 1, maximum of 25. I would like to represent this in a heat map. My VBA skills are zero so would like to know if this can be done in a chart that Excel already has.

Example data

Risk 1 Impact 1 Probability 1 = Risk Total of 1
Risk 2 Impact 4 Probability 3 = Risk total of 12

and so on...


Thanks in advance

Miroslav, this is excellent!!! Exactly what I was after.

Thanks so much, and have some rep. Well deserved!