trend analysis

[Joe C]

I am doing some sales projections. And one of the basic models I was looking to use is the linear trend analysis.
When I do a chart I can find the pick the linear equation. But I need to do this for quite a few different lines. On over forty different charts. I was hoping to use the function that is used to create the linear trend line. Is that the Linest function or the trend function or another function I can use.

 

[Oaktree]

With two variables (one dependent and one independent), consider using either LINEST as an array formula (you have to select two cells, set the third argument of LINEST to TRUE or 1, and enter with CTRL+SHIFT+ENTER to see both the slope and the intercept) or just the SLOPE and INTERCEPT formulas to return the equation in pieces.

 

[Joe C]

I didn't get the exact results and odly the chart intercept was 200000, where my constant was 233838. Does the chart round for visual purposes.