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

[3PlankWalker]

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

 

[3PlankWalker]

Here is the Excel Sheet with Chart Data
https://www.dropbox.com/s/lfnyf4wi1ehys3q/ScatteredPlot.xlsx?dl=0

Thanks

 

[3PlankWalker]

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]

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