charting values...2 axis..based on a 3rd value?

I want
X Axis = RPM
Y Axis = Torque
Only plot it if Throttle Position=100

and I need to be able to tell it to find it on a page that it may not be in the same place every time(meaning sometimes RPM will be in column C..sometimes in column J...I used the Offset and Match commands other portions of my worksheet to make the rest of my stuff find the columns needed automatically)

example data attatched
if you can do it feel free to just add a chart to this and repost it and explain what you did for it

also...Its OK to just plot a scatter style graph...I can make a trend line later or something if necessarry

Something like this perhaps (attached).

I use autofilter to show all Throttle Position with value=100 only

Originally Posted by alexwangsa

Something like this perhaps (attached).

I use autofilter to show all Throttle Position with value=100 only

actually... last night...I discovered a Pivot table was a great thing to do what I wanted to do....
plus the Pivot table would look up the header row for me which was another thing I needed...
so I just graphed by my pivot table and all is well now