TrendlineType Enumeration

In This Topic

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

Members

Member | Description |

**exponential** | Uses an equation to calculate the least squares fit through points. |

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

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

**movingAverage** | 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 to calculate the least squares fit through points. |

**power** | Uses an equation to calculate the least squares fit through points. |

Inheritance Hierarchy

Object

**GC.Spread.Sheets.Charts.TrendlineType**

See Also