How to graph several points that are all dependent on a value.

[zer]

So, I am calculating stresses on a subsea pipeline. I am trying to plot 5 stresses on a graph as a function of depth keeping everything else constant. However, I designed the spreadsheet so I input one specific depth and I get the stresses. Even though the stresses are not just dependent on depth, I want a graph showing how the stresses change with depth keeping all else constant and if I want I can go and change different parameters to see how the graph changes.

I have attached a picture of what the sheet looks like. I'm only looking at the Riser chart. Notice I have one depth input above the table and the chart only shows that one depth (1000) on the X axis. If I change the depth all the values change. I'd like intervals of 0, 1000, 2000..10.000 ft. How would I do this without making a chart for each depth?

Thank you.

[protonLeah]

Attach a sample workbook...