Skip to main content
A newer version of this page is available. .

Trendline.TrendlineType Property

Gets or sets the type of the trendline.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v18.2.Core.dll

Declaration

ChartTrendlineType TrendlineType { get; set; }

Property Value

Type Description
ChartTrendlineType

A ChartTrendlineType enumeration member identifying the trendline type.

Available values:

Name Description
Linear

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

Logarithmic

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

Exponential

Calculates the least squares fit for 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 a 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