A newer version of this page is available. Switch to the current version.

ChartTrendlineType Enum

Specifies how the trendline for a series data is calculated.

Namespace: DevExpress.Spreadsheet.Charts

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

Declaration

public enum ChartTrendlineType

Members

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.

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. The type of the trendline is available by the Trendline.TrendlineType property.

See Also