Add a trend or moving average line to a chart

Add a trendline

1. Select a chart.

2. Select the at the top right of the chart.

3. Select Trendline. and choose 

   Note

   Excel displays the Trendline option only if you select a chart that has more than one data series without selecting a data series.

4. In the Add Trendline dialog box, choose any data series options you want, and select OK.

Format a trendline

1. Select anywhere in the chart.
2. On the Format tab, select the trendline option in the dropdown list in the Current Selection group.
3. Select Format Selection.
4. In the Format Trendline pane, select a Trendline Option to choose the trendline you want for your chart. Formatting a trendline is a statistical way to measure data:
   
5. Set a value in the Forward and Backward fields to project your data into the future.

Add a moving average line

You can format your trendline to a moving average line.

1. Click anywhere in the chart.

2. On the Format tab, in the Current Selection group, select the trendline option in the dropdown list.

3. Click Format Selection.

4. In the Format Trendline pane, under Trendline Options, select Moving Average. Specify the points if necessary.

   Note

   The number of points in a moving average trendline equals the total number of points in the series less the number that you specify for the period.

Add a trendline

1. On the View menu, select Normal.

2. In the chart, choose the data series to add a trendline to, and then select the Chart Design tab. 
   For example, in a line chart, choose one of the lines in the chart, and all the data marker of that data series become selected.
   

3. On the Chart Design tab, select Add Chart Element and choose Trendline.
   

4. Choose a trendline option or select More Trendline Options.
   
   You can choose from the following:

   • Exponential
   • Linear
   • Logarithmic
   • Polynomial
   • Power
   • Moving average

   You can also give your trendline a name and choose forecasting options.

Remove a trendline

1. On the View menu, select Normal.
2. Select the chart with the trendline, and then choose the Chart Design tab.
   
3. Select Add Chart Element, choose Trendline, and pick None.
   
   You can also click the trendline and press DELETE .

1. Select anywhere in the chart to show the Chart tab on the ribbon.
2. Select   Format to open the chart formatting options.
3. Open the Series you want to use as the basis for your Trendline
   
4. Customize the Trendline to meet your needs.
5. Use the switch to show or hide the trendline.