Add a trend or moving average line to a chart

Add a trendline to your chart to show visual data trends.

Select a chart.

Chart
Select the + to the top right of the chart.

Select +
Select Trendline.

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

Format a trendline

Click anywhere in the chart.

Chart
On the Format tab, in the Current Selection group, click Format Selection.

Format Tab
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:

Format Trendline

Add a moving average line

You can format your trendline to a moving average line.

Click anywhere in the chart.

Chart
On the Format tab, in the Current Selection group, click Format Selection.

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

Format Trendline