officefileapi-devexpress-dot-spreadsheet-dot-charts-0e8abf18.md
Specifies how the trendline for a series data is calculated.
Namespace : DevExpress.Spreadsheet.Charts
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public enum ChartTrendlineType
Public Enum ChartTrendlineType
| 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.
|
The following properties accept/return ChartTrendlineType values:
Use the TrendlineCollection.Add to create a Trendline of the specified type and add it to the collection.
See Also