Find point on Line of best fit and project to the axis?

[KroogerFx]

Hi everyone.
I can't for the life of me figure out how to do the following:

I have a scatter plot graph with an exponential trend line on it. I need to have this graph automatically draw a horizontal line from a value on the y axis (4) to the trend line and then down to wherever on the x axis that happens to be.

How would I do this?

Thank you for any help.

[MrShorty]

If I were doing this, I would:

a) Generate the coefficients of the trend line in the spreadsheet using the LINEST() or LOGEST() function
b) using these coefficients, create a small table with three data points

Please Login or Register  to view this content.

c) add this table as a 2nd data series to the scatter plot and format as desired.