Skip to end of metadata
Go to start of metadata

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:

  1. Select Chart > Trendlines.

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

    The following settings are available:

    SettingDescription
    NameThe name of the trendline. This will be displayed in the List of Trendlines.
    TypeThe 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 SeriesThe 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.
    ColourThe colour of the trendline.
    Line ThicknessThe thickness of the trendline. This can be any value between 1 and 30.
    Intercept Y AxisSelect this check box to allow the line to intercept with the y-axis. Not available for Logarithmic, Power and Moving Average trendlines.
    PositionA point on the y-axis indicating the exact position where the trendline must intercept the y-axis.
    Forecast PeriodsThe number of extra periods to forecast in the trendline. This can be any value between 1 and 30.
  3. When you have finished configuring the settings, click Add to add the trendline to the list.
  4. 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.

  • No labels