Query a Line Graph

[Gareth Lockwood]

I have an x,y scatter chart with trend line plotted
through. I want to know exactly what is on the y axis
for any given point on the x axis. i.e. i can pop up a
dialog box asking for x axis input, it then follows this
x axis point up to the trend line then across to the y
axis and displays the result. Is this possible?

 

[Bernard V Liengme]

Lets assume you have a linear trendline. But rather than use a trendline we
will use the TREND function. Suppose you x-values are in A2:A101 and the
y-values in B2:B101. In D1 put the x-value whose y equivalent is needed, in
E1 enter =TREND(B2:B101,A2:A101,D1). This returns the required result.
Bernard