[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.Drawing.TrendlineType

TrendlineType Enum

Specifies how the trendline that smoothes out fluctuations in the data is calculated.

Namespace: GrapeCity.Documents.Excel.Drawing
Assembly: DS.Documents.Excel.dll
Syntax
public enum TrendlineType
Public Enum TrendlineType

Fields

Name Description
Exponential

Uses an equation y=ab^x to calculate that the least squares fit through points.

Linear

Uses the linear equation y = mx + b to calculate that the least squares fit through points.

Logarithmic

Uses the equation y = c ln x + b to calculate that the least squares fit through points.

MovingAvg

Uses a sequence of averages computed from parts of the data series. The number of points equals the total number of points in the series less the number specified for the period.

Polynomial

Uses an equation y = ax^6 + bx^5 + cx^4 + dx^3 + ex^2 + fx + g to calculate that the least squares fit through points.

Power

Uses an equation y = ax^b to calculate that the least squares fit through points.