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

ChartTrendlineType Enum

Specifies how the trendline for a series data is calculated.

Namespace: DevExpress.Spreadsheet.Charts

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

public enum ChartTrendlineType

#Members

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.

#Related API Members

The following properties accept/return ChartTrendlineType values:

#Remarks

Use the TrendlineCollection.Add to create a Trendline of the specified type and add it to the collection.

See Also