Dear All I have plotted X against Y at different values of Z. X Y1 (Y @ Z=1) Y2 (Y @ Z=2) Y3 (Y @ Z=3) 20 2 4 6 40 4 6 8 60 6 8 10 80 8 10 12 Now, I have to interpolate Y for any value between X=20 & X=80 and any value between Z1 & Z3. say..What will be the Y value if X=35 and Z=1.5??

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

How to linear interpolate between two graph??

Thread starter saranyatl
Start date Oct 1, 2014
Tags

excel excel & vba excel & vba 2013 microsoft excel 2010

saranyatl

New Member

Oct 1, 2014

Dear All

I have plotted X against Y at different values of Z.
[TABLE="width: 500"]
<tbody>[TR]
[TD]X
[/TD]
[TD]Y1 (Y @ Z=1)
[/TD]
[TD]Y2 (Y @ Z=2)
[/TD]
[TD]Y3 (Y @ Z=3)
[/TD]
[/TR]
[TR]
[TD]20
[/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]40
[/TD]
[TD]4
[/TD]
[TD]6
[/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD]60
[/TD]
[TD]6
[/TD]
[TD]8
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]80
[/TD]
[TD]8
[/TD]
[TD]10
[/TD]
[TD]12
[/TD]
[/TR]
</tbody>[/TABLE]

Now, I have to interpolate Y for any value between X=20 & X=80 and any value between Z1 & Z3.

say..What will be the Y value if X=35 and Z=1.5??