Chart Properties dialog box – Trendlines tab
Chart Properties shortcut menu > Chart – Trendlines tab
You can add or remove trendlines for each data series in a chart.
Select series
Select a data series to put a trendline on.
Trendline type
Choose what type of trendline to put on the selected data series.
- Add button
Click to add the selected trendline to the chart. - Remove button
Click to remove the selected trendline from the chart.
Displayed trendlines
This list box shows the trendlines that have been added to the chart.
Trendline options
- Interval
Specify the interval for a moving average trendline. Not applicable to other types of trendlines. - Degree
Specify the degree for a polynomial trendline. Not applicable to other types of trendlines. - Show trendlines in legend
Enable this check box to show trendlines in the chart’s legend. This setting applies to all displayed trendlines.