Trendline Members (Word)

Article
09/15/2015

Represents a trendline in a chart.

Methods

Name	Description
ClearFormats	Clears the formatting of the object.
Delete	Deletes the object.
Select	Selects the object.

Properties

Name	Description
Application	When used without an object qualifier, returns an Application object that represents the Microsoft Word application. When used with an object qualifier, returns an Application object that represents the creator of the specified object (you can use this property with an Automation object to return the application of that object). Read-only.
Backward2	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Read/write Double.
Border	Returns the border of the object. Read-only ChartBorder.
Creator	Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.
DataLabel	Returns the data label that is associated with the trendline. Read-only DataLabel.
DisplayEquation	True if the equation for the trendline is displayed on the chart (in the same data label as the R-squared value). Read/write Boolean.
DisplayRSquared	True if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). Read/write Boolean.
Format	Returns the line, fill, and effect formatting for the object. Read-only ChartFormat.
Forward2	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. Read/write Double.
Index	Returns the index number of the object within the collection of similar objects. Read-only Long.
Intercept	Returns or sets the point where the trendline crosses the value axis. Read/write Double.
InterceptIsAuto	True if the point where the trendline crosses the value axis is automatically determined by the regression. Read/write Boolean.
Name	Returns or sets name of the object. Read/write String.
NameIsAuto	True if Microsoft Word automatically determines the name of the trendline. Read/write Boolean.
Order	Returns or sets the trendline order (an integer greater than 1) when the trendline type is xlPolynomial. Read/write Long.
Parent	Returns the parent for the specified object. Read-only Object.
Period	Returns or sets the period for the moving-average trendline. Read/write Long.
Type	Returns or sets the trendline type. Read/write XlTrendlineType.