After seeing the chart, you probably already know the answer.Ĭonclusion: in this example, when using the FORECAST.ETS function, you can also use the value 4 for the fourth argument. In the Trendline group, click on the Add Trendline button. You can use the function to find the length of the seasonal pattern. To do this, select your data series, then click on the Chart Tools tab. Enter the value 49 into cell C13, select the range A1:C17 and insert a scatter plot with straight lines and markers.ģ. Create a line chart using the data in the range A2:G6, then move and resize the chart to fit in the range A8:G20. The default value of 1 indicates seasonality is detected automatically.Ģ. The fourth argument indicates the length of the seasonal pattern. The FORECAST.ETS function below predicts a future value using Exponential Triple Smoothing.

Learn how to add trendline formulas and equations in Excel in this video tutorial. The FORECAST.ETS function in Excel 2016 or later is a great function which can detect a seasonal pattern.ġ. In Excel you can add a trendline to your chart to show visual data trends. This equation predicts the same future values. Note: when you add a trendline to an Excel chart, Excel can display the equation in a chart.

Enter the value 89 into cell C11, select the range A1:C14 and insert a scatter plot with straight lines and markers. Explanation: when we drag the FORECAST.LINEAR function down, the absolute references ($B$2:$B$11 and $A$2:$A$11) stay the same, while the relative reference (A12) changes to A13 and A14.Ģ.

How to add trend lines in excel 2016