Skip to main content

Trendline.TrendlineType Property

Gets or sets the type of the trendline.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

ChartTrendlineType TrendlineType { get; set; }

Property Value

Type Description
ChartTrendlineType

A ChartTrendlineType enumeration member that indicates the trendline type.

Available values:

Name Description
Linear

Calculates the least squares fit for the line y = m * x + b.

Logarithmic

Calculates the number of squares that fit for the logarithmic curve y = a * ln(x) + b, where ln is the natural logarithm.

Exponential

Calculates the least number of squares that fit the exponential curve y = a * b^x.

MovingAverage

Uses a sequence of averages calculated across each set of N consecutive values, where N is the number specified for the Trendline.Period.

Polynomial

Calculates the least square fit using a polynomial curve of order equal to the number specified by the Trendline.Order property. The equation is in the form y = b + (c1 * x) + (c2 * x^2) + … + (cN * x^N) where N is the trendline order.

Power

Calculates a least square fit for a power curve in the form y = a * x^b.

See Also