A Trendline.Regression value specifies the type of trendline to display on the graph.

 public sealed class Regression : TypesafeEnum
Public NotInheritable Class Regression
		Inherits TypesafeEnum

A linear trendline can be achieved by setting the Trendline.RegressionType to Polynomial, and the Trendline.RegressionValue to 1.

Name

Description

Exponential

A curved line that is most useful when data values rise or fall at increasingly higher rates. You cannot create an exponential trendline if your data contains zero or negative values.

Logarithmic

A best-fit curved line used when the rate of change in the data increases or decreases quickly and then levels out.

MovingAverage

A line that smoothes out fluctuations in data to show a pattern or trend more clearly.

Polynomial

A curved line used when data fluctuates. The order of the polynomial can be determined by the number of fluctuations in the data or by how many bends (hills and valleys) appear in the curve.

Power

A curved line that is best used with data sets that compare measurements that increase at a specific rate.