2x2 Matrix - How do I?

[LGDWilliams]

Would like to be able to generate a simple 2x2 matrix where one axis is Probability and another is Severity. Idea is that individual risks can be plotted on the matrix. I.e. Risk 1 has a Probability (P) of 5 and Severity of (S) of 5 will put it in the centre and Risk 2 that has a P1; S2 will be in the bottom left hand corner, unlike risk 3 that is P8; S8 and is therefore in the top right hand corner.

How do I a) set up a table to log the P and S values and b) plot these as a single spot on the 2x2 matrix

Any help gratefully received.

Many thanks,

 

[oldbrewer]

a chart plotting every point from 0,0 to 10,10

once there are hundreds of risks it will not be possible to put risk names on the chart....

 

[LGDWilliams]

a chart plotting every point from 0,0 to 10,10

once there are hundreds of risks it will not be possible to put risk names on the chart....

Thank you for the quick reply - much appreciated. However, could you be so kind as to provide an example or a wee bit more detail for those less expert?

 

[GuidoBR]

Man, you have a 2D question.. in your 'x' axis you have Probability (P) and in 'y' axis you have Severity (S). Every point in this chart is identified according it's (P,S) location.
If I were you, I wouldn't built a plot.. I would make a square with P columns and S rows and use conditional formatting to paint the cell that is in (P,S) position.

 

[oldbrewer]

[TABLE="width: 256"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I highlighted this data and selectedxy chart and got a plot of the 10 pairs on a chart from 0,0 to 10,10[/TD]
[/TR]
</tbody>[/TABLE]
dont know how to show charts on here....