Reading values from table to plot on graph

[delwar130]

Hello guys,

I am working on an assignment, am trying to display the corresponding number/value on a cell based on a table. To understand this better please see the attached sheet.

Here is an example of what I am trying to achieve:
Capture2.JPG

In the attached Image, you will see there is a graph I am plotting from a table. The number(s) are displayed from the table of the conditions for severity and probability is met. Right now I entered the values manually. If anyone can help me with possible formula or if statements that will display these numbers and also separate each value with a comma or space it will be of great help.

I have attached the excel sheet as well, please let me know if more information is needed.

Thanks in advance.

[Limor_OP]

Which values did you type manually, and where do you want your formulas ?