Graph: Given X, Find Y

[MattF]

Hi Everyone,

I have tried to recreate a graph given to me on paper by taking a few points and ploting them in excel. I now want to find a function to return the Y value for a given X in the range of the graph. I have tried using the trend function but the regression line does not come close to the graph I have created.

Is there a way for a function to just "read" the line of the graph, not a regression line, and return a Y value based on a given X?

 

[swat2]

Is the function a simple line or a polynomial? You can also set the regression options to include some points ( think first or last)

 

[iliace]

If it's polynomial, LINEST will do any degree polynomial, not just linear. It's described in the help file.