Macro for a graph??

[mzalikhan]

Hi everybody

I have 4 columns, Say H1, T1, T2 and T3. H1 is height, where Ts are temperatures. I have to plot all the three Ts on the graph (X-axis) against H1 (Y-axis). Lets name the resultant lines that we obtain on the graph as:

H1 Vs T1; L1
H1 Vs T2; L2
H1 Vs T3; L3

Now the purpose of doing all this is to know the value of H (Y-axis) on the points where T2 (Vs H1) and T3 intersect the T1.

Is there any technique/macro to do that? Because i have got around 4,000 sets of data to do this same thing.

Peace.

 

[mzalikhan]

Anybody there??