XlTrendlineType enumeration
Office 2013 and later
Specifies how the trendline that smoothes out fluctuations in the data is calculated.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
| Member name | Description | |
|---|---|---|
| xlExponential | Uses an equation to calculate the least squares fit through points. | |
| xlLinear | Uses the linear equation y = mx + b to calculate the least squares fit through points. | |
| xlLogarithmic | Uses the equation y = c ln x + b to calculate the least squares fit through points. | |
| xlMovingAvg | 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. | |
| xlPolynomial | Uses an equation to calculate the least squares fit through points. | |
| xlPower | Uses an equation to calculate the least squares fit through points. |
Show: