Finding a specific datapoint on a graph

[Jeff Vandehey]

Hi, I have some excel data that I made an x-y scatter plot of. For sake of
illustration, let's say that it is a linear graph, 0-1 on Y axis, and 0-10
on the x axis. My question is, how do I find out the exact X value, when Y
is at .5? I don't have a datapoint for .5 (say I have .4 and .6), how can I
find it's value?

If it was truly a linear graph this would be easy, but it's actually a
curve. How do I find the value on the graph? Thanks a ton for the help.

Regards,
Jeff

 

[JE McGimpsey]

One way:

For linear data:

=TREND(B1:B10,A1:A10,4.5)

for exponential data:


=GROWTH(B1:B10,A1:A10,4.5)