complex charting/graph

I would like to plot a graph of 30 points from the data below...
I have 7 columns (A1, B1, C1...G1) which are the YEARS 1, 5, 10, 15, 20, 25, 30 in which dollars amounts listed below are in cells A2-A31, B2-B31... G2-G31 respectively. I would like the graph to chose a column based on another cell elsewhere in my sheet (for instance B59 will have either the value 1, 5, 10, 15, 20, 25, or 30 in it). Whatever the value in B59 is, I would like the graph to look for it in A1-G1 and plot the respective numbers below it. Hope that makes sense.

Any help is appreciated,
Thanks

I don't know what F25*12 means, but whatever. I've reproduced your data below. In cell I10 I've put a value I want from A1:G1. The formula in I2 is:

=INDEX(A2:G2,MATCH($I$1,$A$1:$G$1))

I've filled this down to I31.

LookupColumn.png