Why did You something like that?
I made some changes in the code due to the change in risk rating calculation. Earlier it was based on the composite score (chk_ef = chk_e * chk_f). But if I take composite score, 9 is coming in both Moderate and High as highlighted below. Hence, I need it to be based on the X and Y axis position in the heat map.
Didn't my code work?
Your code is working perfectly. I can do only minor changes as I'm completely a newbie to VBA.
I thought of making the changes wherever I can and ask your help otherwise you will fire me for the change request.
Request your help in the following
1) Below is the change required in calculation
Do nothing if chk_e = "" Or chk_f = 0
Low
chk_e <= 1.5 And chk_f <= 2.5
chk_e <= 2.5 And chk_f <= 1.5
Moderate
chk_e <= 1.5 And chk_f <= 5.5
chk_e <= 2.5 And chk_f <= 4.5
chk_e <= 3.5 And chk_f <= 3.5
chk_e <= 4.5 And chk_f <= 2.5
chk_e <= 5.5 And chk_f <= 1.5
Else
High
2) It looks like data labels are over lapping due to my likelihood score and impact scores are very close after the actual risk assessment.
3) Can you help to map the bg color as data label font color (Green, Orange and Red).
4) Exclude numbers if either likelihood score or impact score is blank. (blanks are due to functions are pending for risk assessment).