On the Layout tab, in the Analysis group, click Trendline, and then click the type of regression trendline or moving average that you want. If you have not done so, see the topic Create a chart.Ĭlick the data series to which you want to add a trendline or moving average. This procedure assumes that you already created a chart that is based on existing data.

For example, if you have a chart in Excel that shows sales data for the first several months of the year, you can add a trendline to the chart that shows the general trend of sales (increasing or decreasing or flat) or that shows the projected trend for months ahead. When you have existing data for which you want to forecast a trend, you can create a trendline in a chart. In the Stop value box, enter the value that you want to stop the series at. The resulting product and each subsequent product are then multiplied by the step value. The first starting value is multiplied by the step value. The step value is added to the first starting value and then added to each subsequent value. In the Step value box, enter the value that you want to increase the series by. To fill the series across the worksheet, click Rows. To fill the series down the worksheet, click Columns. On the Home tab, in the Editing group, click Fill, and then click Series. If you want to save the original values, copy them to a different row or column, and then create the series by selecting the copied values. When you click the Series command, the resulting series replaces the original selected values. The cell must contain the first value in the series. Select the cell where you want to start the series. To fill in the values manually, do the following: The series that is created is equivalent to the values that are returned by the TREND function or GROWTH function. In either case, the step value is ignored. In a growth series, the starting values are applied to the exponential curve algorithm (y=b*m^x) to generate the series. In a linear series, the starting values are applied to the least-squares algorithm (y=mx+b) to generate the series. When you click the Series command, you can manually control how a linear trend or growth trend is created and then use the keyboard to fill in the values.

Excel how to get trendline equation