Add a trend or moving average line to a chart
Add a trendline to your chart to show visual data trends.
Note: These steps apply to Office 2013 and newer versions. Looking for Office 2010 steps?
Add a trendline
-
Select a chart.
-
Select the + to the top right of the chart.
-
Select Trendline.
Note: Excel displays the Trendline option only if you select a chart that has more than one data series without selecting a data series.
-
In the Add Trendline dialog box, select any data series options you want, and click OK.
Format a trendline
-
Click anywhere in the chart.
-
On the Format tab, in the Current Selection group, select the trendline option in the dropdown list.
-
Click Format Selection.
-
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:
-
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.
-
Click anywhere in the chart.
-
On the Format tab, in the Current Selection group, select the trendline option in the dropdown list.
-
Click Format Selection.
-
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 trend or moving average line to a chart in Office 2010
Add a trendline (Office 2010)
Change the format of a trendline (Office 2010)
Specify the number of periods to include in a forecast (Office 2010)
Specify the point where the trendline crosses the vertical (value) axis (Office 2010)
Display the trendline equation on the chart (Office 2010)
Display the R-squared value for a trendline (Office 2010)
Remove a trendline (Office 2010)
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.