For making projections, I would like to extrapolate my data using the parameters from the fitted trend line in a graph/chart. At present I need to type this information into the cells every time the fit changes. Is there any way to make a reference in a cell to the fit parameters. That would be awesome!
I’m not sure, If I got you right, but for linear trendline there is a
SLOPE() and a
INTERCEPT() function to get the parameters required for a linear function and with these you can perform a linear extrapolation.
In the example below