This documentation is archived and is not being maintained.

Trendline Properties

The Trendline type exposes the following members.

  NameDescription
Public property Application When used without an object qualifier, this property returns an _Application object that represents the Microsoft Word application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Public property Backward Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward.
Public property Backward2 Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Read/write Double.
Public property Border Returns a ChartBorder object that represents the border of the object. Read-only.
Public property Creator Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Integer.
Public property DataLabel Returns a DataLabel object that represents the data label associated with the trendline. Read-only.
Public property 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. Read/write Boolean.
Public property 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. Read/write Boolean.
Public property Format Returns the line, fill, and effect formatting for the object. Read-only ChartFormat.
Public property Forward Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward.
Public property Forward2 Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. Read/write Double.
Public property Index Returns the index number of the object within the collection of similar objects.
Public property Intercept Returns or sets the point where the trendline crosses the value axis. Read/write Double.
Public property InterceptIsAuto True if the point where the trendline crosses the value axis is automatically determined by the regression. Read/write Boolean.
Public property Name Returns or sets a String value that represents the name of the object.
Public property NameIsAuto True if Microsoft Word automatically determines the name of the trendline. Read/write Boolean.
Public property Order Returns or sets a Integer value that represents the trendline order (an integer greater than 1) when the trendline’s Type is xlPolynomial.
Public property Parent Returns the parent for the specified object. Read-only Object.
Public property Period Returns or sets the period for the moving-average trendline. Can be a value from 2 through 255. Read/write Integer.
Public property Type Returns or sets a XlTrendlineType value that represents the trendline type.
Top
Show: