Trendlines.Add Method
Creates a new trendline.
Syntax
expression.Add(Type, Order, Period, Forward, Backward, Intercept, DisplayEquation, DisplayRSquared, Name)
expression A variable that represents a Trendlines object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Type | Optional | XlTrendlineType | The trendline type. |
| Order | Optional | Variant | Variant. if Type is xlPolynomial. The trendline order. Must be an integer from 2 to 6, inclusive. |
| Period | Optional | Variant | if Type is xlMovingAvg. The trendline period. Must be an integer greater than 1 and less than the number of data points in the series you're adding a trendline to. |
| Forward | Optional | Variant | The number of periods (or units on a scatter chart) that the trendline extends forward. |
| Backward | Optional | Variant | The number of periods (or units on a scatter chart) that the trendline extends backward. |
| Intercept | Optional | Variant | The trendline intercept. If this argument is omitted, the intercept is automatically set by the regression. |
| DisplayEquation | Optional | Variant | True to display the equation of the trendline on the chart (in the same data label as the R-squared value). The default value is False. |
| DisplayRSquared | Optional | Variant | True to display the R-squared value of the trendline on the chart (in the same data label as the equation). The default value is False. |
| Name | Optional | Variant | The name of the trendline as text. If this argument is omitted, Microsoft Excel generates a name. |
Return Value
A Trendline object that represents the new trendline.
Example
This example creates a new linear trendline in Chart1.
| Visual Basic for Applications |
|---|
|