ActiveReports 17 .NET Edition
Report Authors: Designer Components / Report Controls / Page/RDL Report / Chart / Trendlines
In This Topic
    Trendlines
    In This Topic

    You can add a trendline element to the chart to display additional information like a trendline for the chart data, reference information, and more. A trendline is a helpful element for the analysis of chart data.

    The following trendline types are available.

    Property Description
    Aggregate Type (Reference Line) Sets the reference line aggregation fuction. Select from Sum, Count, Average, Max, Min, Median, and Percentile.
    Axis Specifies the axis to which the reference line belongs. Select from X or Y.
    BackwardForecastPeriod (Linear Trendline, Exponential Trendline, Power Trendline, Logarithmic Trendline, Polynomial Trendline, Fourier Trendline) Sets a number of periods that the forecast extends backward.
    DetailLevel Specifies if the overlay calculation should include the entire data set or each detail group. Select from Total or Group.
    End (Reference Band) Specifies the end position on the value axis or the end index on the category axis.
    Start (Reference Band) Specifies the start position on the value axis or the start index on the category axis.
    FieldName Sets the field name for the reference line to use.
    ForwardForecastPeriod (Linear Trendline, Exponential Trendline, Power Trendline, Logarithmic Trendline, Polynomial Trendline, Fourier Trendline) Sets a number of periods that the forecast extends forward.
    Intercept (Linear Trendline, Exponential Trendline, Power Trendline, Logarithmic Trendline, Polynomial Trendline, Fourier Trendline) Sets the intercept value of Y-axis.
    Order (Polynomial Trendline, Fourier Trendline) Sets a number of terms in the Polynomial equation. The default value is 2, the value less than 2 is treated as 2, values greater than 6 are treated as 6.
    Period (MovingAverage Trendline, CumulativeMovingAverage Trendline, ExponentialMovingAverage Trendline, WeightedMovingAverage Trendline, MovingAnnualTotal Trendline) Specifies the number of data values used to create a line. The default value is 2.
    LegendLabel Sets the legend label of the reference line.
    Value Sets the position of the specified axis.

    Display

    Sets the display position. Select from Front or Back.

    Name

    Enter the name of the trendline.
    Type Select the type of the trendline from the list of available types.
    LineStyle Sets the style of the line. Select the LineColor, LineStyle and LineWidth properties of the line.
    BackgroundColor (Reference Band) Select the color to use for the background, or select the <Expression...> option to open the Expression Editor and create an expression that evaluates to a .NET color.

    To add a trendline

    1. Select a Сhart plot.
    2. In the Properties window, go to the Overlays property and click (Collection).
    3. In the OverlayDesigner Collection Editor that opens, click Add to add a new overlay.
      OverlayDesigner Collection Editor
    4. Specify the Type property and other important properties.
    5. Click OK.

    Reference Line

    A Reference Line is a static line, drawn at a single point along a single axis that stretches indefinitely along the opposite axis. You can set the line's position or have it calculated by the data set. For example, you may want to add a reference line at the average value to see how each value is compared against the average. 

    Chart Trendlines - Reference Line

    In the OverlayDesigner Collection Editor, you can set a Reference Line with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > AggregateType Average
    Configurations > Axis Y
    Configurations > DetailLevel Total
    Configurations > LegendLabel Average
    General > Display Front
    General > Type ReferenceLine

    Reference Band

    A Reference Band is a shaded area, which is positioned along a single axis between two calculated values and extend indefinitely along the opposite axis. Each band has a start and end position that you set in the Properties.

    This overlay type is not available for Candlestick, High Low Close, and High Low Open Close type charts.

    Chart Trendlines - Reference Band

    In the OverlayDesigner Collection Editor, you can set a Reference Band with the properties as follows.

    Property Value
    BackgroundColor Green
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > Axis Y
    Configurations > End 20
    Configurations > Start 10
    General > Display Back
    General > Type ReferenceBand

    Linear Trendline

    A Linear trendline creates a best fit straight line that shows how values in a data series increase or decrease at a steady rate. This trendline uses the following equation:

    y=mx + b

    where "m" is the slope and "b" is the intercept.

    Chart Trendlines - Linear

    In the OverlayDesigner Collection Editor, you can set a Linear trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > BackwardForecastPeriod 0
    Configurations > DetailLevel Total
    Configurations > ForwardForecastPeriod 0
    General > Display Front
    General > Type LinearTrendline

    Exponential Trendline

    An Exponential trendline creates a best-fit curved line that illustrates how data values increase or decrease and then level out. You can use this trendline only with positive numbers. If the data series contains any zero or negative numbers, then this trendline is not available.

    This trendline uses the following equation:

    y=cebx

    where "c" and "b" are constants, and "e" is the base of the natural logarithm.

    Chart Trendlines - Exponential

    In the OverlayDesigner Collection Editor, you can set an Exponential trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > BackwardForecastPeriod 0
    Configurations > DetailLevel Total
    Configurations > ForwardForecastPeriod 0
    General > Display Front
    General > Type ExponentialTrendline

    Power Trendline

    A Power trendline creates a curved line to compare measurements that increase at a specific rate. You can use this trendline only with positive numbers. If the data series contains any zero or negative numbers, then this trendline is not available.

    This trendline uses the following equation:

    y = ax^b

    where "a" and "b" are constants.

    Chart Trendlines - Power

    In the OverlayDesigner Collection Editor, you can set a Power trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > BackwardForecastPeriod 0
    Configurations > DetailLevel Total
    Configurations > ForwardForecastPeriod 0
    General > Display Front
    General > Type PowerTrendline

    Logarithmic Trendline

    A Logarithmic trendline creates a best-fit curved line that illustrates how data values increase or decrease and then level out. This trendline uses the following equation:

    y=c ln x + b

    where "c" and "b" are constants, and "ln" is the natural logarithm function.

    Chart Trendlines - Logarithmic

    In the OverlayDesigner Collection Editor, you can set a Logarithmic trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > BackwardForecastPeriod 0
    Configurations > DetailLevel Total
    Configurations > ForwardForecastPeriod 0
    General > Display Front
    General > Type LogarithmicTrendline

    Polynomial Trendline

    A Polynomial trendline creates a curved line, illustrating fluctuations in the data values. The trendline uses the following equation:

    y=b+c1x+c2x2+c3x3+

    where c1, c2, c3 are constants.

    Chart Trendlines - Polynomial

    In the OverlayDesigner Collection Editor, you can set a Polynomial trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > BackwardForecastPeriod 0
    Configurations > DetailLevel Total
    Configurations > ForwardForecastPeriod 0
    Configurations > Order 2
    General > Display Front
    General > Type PolynomialTrendline

    Fourier Trendline

    A Fourier trendline creates a trendline, based on Fourier Series.

    Chart Trendlines - Fourier

    In the OverlayDesigner Collection Editor, you can set a Fourier trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > BackwardForecastPeriod 0
    Configurations > DetailLevel Total
    Configurations > ForwardForecastPeriod 0
    Configurations > Order 1
    General > Display Front
    General > Type FourierTrendline

    MovingAverage Trendline

    A MovingAverage trendline reduces the fluctuations in the trendline to show a smoother pattern. This trendline uses the following equation:

    Ft = (At + At-1 + At-2 ) / n

    Chart Trendlines - Moving Average

    In the OverlayDesigner Collection Editor, you can set a MovingAverage trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > DetailLevel Total
    Configurations > Period 2
    General > Display Front
    General > Type MovingAverageTrendline

    CumulativeMovingAverage Trendline

    In a CumulativeMovingAverage trendline, the data arrive in an ordered datum stream, and you get the average of all data up until the current datum point.

    Chart Trendlines - Cumulative Moving Average

    In the OverlayDesigner Collection Editor, you can set a CumulativeMovingAverage trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > DetailLevel Total
    Configurations > Period 2
    General > Display Front
    General > Type CumulativeMovingAverageTrendline

    ExponentialMovingAverage Trendline

    An exponential moving average (EMA), also known as an exponentially weighted moving average (EWMA), is a first-order infinite impulse response filter that applies weighting factors, which decrease exponentially. The weighting for each older datum decreases exponentially, never reaching zero.

    Chart Trendlines - Exponential Moving Average

    In the OverlayDesigner Collection Editor, you can set an ExponentialMovingAverage trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > DetailLevel Total
    Configurations > Period 2
    General > Display Front
    General > Type ExponentialMovingAverageTrendline

    WeightedMovingAverage Trendline

    A WeightedMovingAverage trendline is an average that has multiplying factors to give different weights to data at different positions. Mathematically, the moving average is the convolution of the datum points with a fixed weighting function. 

    Chart Trendlines - Weighted Moving Average

    In the OverlayDesigner Collection Editor, you can set a WeightedMovingAverage trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > DetailLevel Total
    Configurations > Period 2
    General > Display Front
    General > Type WeightedMovingAverageTrendline

    MovingAnnualTotal Trendline

    A MovingAnnualTotal trendline is a moving total of the prior 'n' points at an abstract level. 

    Chart Trendlines - Moving Annual Total

    In the OverlayDesigner Collection Editor, you can set a MovingAnnualTotal trendline with the properties as follows.

    Property Value
    LineStyle > LineColor Red
    LineStyle > LineStyle Solid
    LineStyle > LineWidth 3pt
    Configurations > DetailLevel Total
    Configurations > Period 2
    General > Display Front
    General > Type MovingAnnualTotalTrendline