Excel uses a log transformation of the original y data to determine fitted values. The 'new_x' values are in cells A24:C24, where B24 and C24 are the formulas as shown. The exponential model creates a trendline using the equation y c ebx. The 'known_y' values are in green in E3:E22 For example, if the equation for January.
The 'known_x' values are in green in A3:C22 Calculate the y-values (i.e., the sales figures) for the starting and ending points using the trendline equation. If you change the values in E3:E22, the trend() function will update Cell E24 for your new input at Cell A24.Įdit = Open the internal datasheet and add a new series, e.g., 'Trendline 1'.
The trend() formula is in Cell E24 where the cell references are shown in red.Ĭell A24 contains the new X, and is the cell to change to update the formula in E24Ĭell B24 contains the X^2 formula (A24*A24) for the new XĬell C24 contains the X^3 formula (A24*A24*A24) for the new X Trendline This example teaches you how to add a trendline to a chart in Excel. To create a trendline in a line chart, add a new series to the line chart, then calculate its values to form a trendline, e.g., by using the TREND function of Excel. Column C is X^3 (two cells to the left cubed). A moving average trendline smoothes out fluctuations in data to show a pattern or trend more clearly.
Column B is X^2 (the cell to the left squared). Try trend(known_y's, known_x's, new_x's, const).Ĭolumn A below is X.