# In Scattered Plot data is it possible to find Xvalue from the Yvalue

#### 3PlankWalker

##### Board Regular
In Scattered Plot data is it possible to find Xvalue from the Yvalue.

Here is the image of the Scattered Plot
Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting

Example Yvalue = 1000
Xvalue = 225

I Tried Excel XY Chart Variations with VBA

Interpolation But i Couldn't find Solution.

Thanks

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

#### 3PlankWalker

##### Board Regular
I have tried Analysis--> Trending Tool in Excel but bestfit Trend line "Two Point Moving Average" doesn't give the equation for the Trendline. Still looking for a solution. Thanks

#### 3PlankWalker

##### Board Regular
I looked around and found this which works for me.

I arranged your data like this:

Note the horizontal axis variable is in the first column.

Cell B2 is the value we want to match in the second column.
Cell B3 contains this formula:
=MATCH(B2,B6:B18)
Cell A2 contains this interpolation formula:
=(B2-INDEX(B6:B18,B3))/(INDEX(B6:B18,B3+1)-INDEX(B6:B18,B3))*(INDEX(A6:A18,B3+1)-INDEX(A6:A18,B3))+INDEX(A6:A18,B3)

The following chart shows Flow vs. Gauge as blue diamonds, and the interpolated point as a red square:

When I enter 0.35 into cell B2, A2 calculates 0.400368, and the chart looks like this:

Thanks

Replies
1
Views
467
Replies
1
Views
379
Replies
0
Views
227
Replies
0
Views
923
Replies
7
Views
348

### Forum statistics

1,190,735
Messages
5,982,646
Members
439,789
Latest member
Justhavinaltlfun2002

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back