extrapolating points on a trendline

[Saied]

Hi Everyone!

This is a time sensitive issue for me, so I'd appreciate a response asap

I made a scatter plot graph and added a trendline. I want to know how I can
extrapolate points on that trendline. For instance, I want to show that at 24
mm on the x axis I obtain 2000 bp on the y axis. How do you do this exel? Is
there such a way to add values to your graph without screwing up the
trendline.

 

[Jon Peltier]

An option on a trendline is to forecast forward and backward from the
endpoints.

Alternatively you can use TREND() in the worksheet, or calculate your
SLOPE() and INTERCEPT() and calculate values. If you plot these in the
chart, plot them in a new series.

- Jon