[]
Represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.
public interface ITrendline
Public Interface ITrendline
| Name | Description |
|---|---|
| Backward | Gets or sets the number of periods (or units on a scatter chart) that the trendline extends backward. |
| DataLabel | Returns a IDataLabel object that represents the data label associated with the trendline. |
| DisplayEquation | Gets or sets whether to display the equation for the trendline (True if the equation for the trendline is displayed on the chart, in the same data label as the R-squared value). Setting this property to True automatically turns on data labels. |
| DisplayRSquared | Gets or sets whether to display the R-squared value (True if the R-squared value of the trendline is displayed on the chart, in the same data label as the equation). Setting this property to True automatically turns on data labels. |
| Format | Returns the format for chart elements. |
| Forward | Gets or sets the number of periods (or units on a scatter chart) that the trendline extends forward. |
| Index | Returns the index number of the object within the collection of similar objects. |
| Intercept | Gets or sets the point where the trendline crosses the value axis. |
| Name | Returns or sets a String value representing the name of the object. |
| NameIsAuto | Get or set if the trendline's name is automatically determined. |
| Order | Gets or sets the trendline order (an integer is greater than or equal to 2 and less than or equal to 6) when the trendline type is Polynomial. |
| Parent | Returns the parent object for the specified object. |
| Period | Gets or sets the period for the moving-average trendline. |
| Type | Gets or sets the trendline type. |
| Name | Description |
|---|---|
| ClearFormats() | Clears the formatting of the object. |
| Delete() | Deletes the object. |