Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

Trendline.TrendlineType Property

Gets or sets the type of the trendline.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v24.2.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