Trendline Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.
public interface class Trendline
[System.Runtime.InteropServices.Guid("000208BE-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Trendline
Public Interface Trendline
- Attributes
Remarks
The Trendline object is a member of the Trendlines collection. The Trendlines collection contains all the Trendline objects for a single series.
Use Trendlines(index
), where index
is the trendline index number, to return a single Trendline object.
The index number denotes the order in which the trendlines were added to the series. Trendlines(1) is the first trendline added to the series, and Trendlines(Trendlines.Count) is the last one added.
Properties
Application |
Returns an Application object that represents the Microsoft Excel application. |
Backward |
Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. |
Backward2 |
Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Read/write. |
Border |
Returns a Border object that represents the border of the object. |
Creator |
Returns a 32-bit integer that indicates the application in which this object was created. |
DataLabel |
Returns a DataLabel object that represents the data label associated with the point or trendline. |
DisplayEquation |
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 |
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. Read-only. |
Forward |
Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. |
Forward2 |
Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. Read/write. |
Index |
Returns the index number of the object within the collection of similar objects. |
Intercept |
Returns or sets the point where the trendline crosses the value axis. |
InterceptIsAuto |
True if the point where the trendline crosses the value axis is automatically determined by the regression. |
Name |
Returns or sets the name of the object. |
NameIsAuto |
True if Microsoft Excel automatically determines the name of the trendline. |
Order |
Returns or sets the trendline order (an integer greater than 1) when the trendline type is xlPolynomial. |
Parent |
Returns the parent object for the specified object. |
Period |
Returns or sets the period for the moving-average trendline. |
Type |
Returns or sets the trendline type. |
Methods
ClearFormats() |
Clears the formatting of the object. |
Delete() |
Deletes the object. |
Select() |
Selects the object. |