# Trendlines

Trendlines allows simple linear and growth trend series to be created and displayed based on existing data. They are commonly used to study predictions (regression analysis) and can be used to indicate moving averages, where data fluctuations are smoothed to represent a pattern or trend.

A trendline can be added to a data series in a chart to indicate the trend, or direction of the data.

Only area, bar, column, line and XY (scatter) charts can create and display trendlines.

They are not available for 3D, pie, and radar charts.

To add a trendline:

- Select
**Chart > Trendlines**.

The**Trendlines**window displays. Define the trendline settings.

The following settings are available:

Setting Description **Name**The name of the trendline. This will be displayed in the **List of Trendlines**.**Type**The trendline type. The following options are available: **Linear**- A calculation of the least squares fit.**Logarithmic**- A calculation of the logarithmic least squares fit through a series of data points.**Polynomial**- A calculation of the polynomial least squares fit through a series of data points.**Power**- A calculation of the least squares fit through a series of data points.**Exponential**- A calculation of the least squares fit through a series of data points.**Moving Average**- A sequence of averages derived from parts of a data series.

**Order**(Only applicable to **Polynomial**). The order of the polynomial. This can be any value between 2 and 10 inclusive.**Period**(Only applicable to **Moving Average**). The number of periods that the moving average trendline is based on. This can be any value between 2 and 10 inclusive.**Based on Series**The series that the trendline will be based on. The value depends on the number of series in the currently selected chart layer. Series are zero based, therefore, the first series is 0. **Colour**The colour of the trendline. **Line Thickness**The thickness of the trendline. This can be any value between 1 and 30. **Intercept Y Axis**Select this check box to allow the line to intercept with the y-axis. Not available for **Logarithmic**,**Power**and**Moving Average**trendlines.**Position**A point on the y-axis indicating the exact position where the trendline must intercept the y-axis. **Forecast Periods**The number of extra periods to forecast in the trendline. This can be any value between 1 and 30. - When you have finished configuring the settings, click
**Add**to add the trendline to the list. - Click
**OK**to close the**Trendlines**window and view the updated chart.

You can reopen the **Trendlines** window and add additional lines. To remove a line, select it in the list and click **Remove**.