Trendline Object Members

  • Article

Represents a trendline in a chart.

Methods

  Name Description
Ee409233.methods(en-us,office.12).gif ClearFormats Clears the formatting of the object.
Ee409233.methods(en-us,office.12).gif Delete Deletes the object.
Ee409233.methods(en-us,office.12).gif Select Selects the object.

Properties

  Name Description
Ee409233.properties(en-us,office.12).gif 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.
Ee409233.properties(en-us,office.12).gif Backward2 Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Read/write Double.
Ee409233.properties(en-us,office.12).gif Border Returns the border of the object. Read-only ChartBorder.
Ee409233.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.
Ee409233.properties(en-us,office.12).gif DataLabel Returns the data label that is associated with the trendline. Read-only DataLabel.
Ee409233.properties(en-us,office.12).gif 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.
Ee409233.properties(en-us,office.12).gif 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.
Ee409233.properties(en-us,office.12).gif Format Returns the line, fill, and effect formatting for the object. Read-only ChartFormat.
Ee409233.properties(en-us,office.12).gif Forward2 Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. Read/write Double.
Ee409233.properties(en-us,office.12).gif Index Returns the index number of the object within the collection of similar objects. Read-only Long.
Ee409233.properties(en-us,office.12).gif Intercept Returns or sets the point where the trendline crosses the value axis. Read/write Double.
Ee409233.properties(en-us,office.12).gif InterceptIsAuto True if the point where the trendline crosses the value axis is automatically determined by the regression. Read/write Boolean.
Ee409233.properties(en-us,office.12).gif Name Returns or sets name of the object. Read/write String.
Ee409233.properties(en-us,office.12).gif NameIsAuto True if Microsoft Word automatically determines the name of the trendline. Read/write Boolean.
Ee409233.properties(en-us,office.12).gif Order Returns or sets the trendline order (an integer greater than 1) when the trendline type is xlPolynomial. Read/write Long.
Ee409233.properties(en-us,office.12).gif Parent Returns the parent for the specified object. Read-only Object.
Ee409233.properties(en-us,office.12).gif Period Returns or sets the period for the moving-average trendline. Read/write Long.
Ee409233.properties(en-us,office.12).gif Type Returns or sets the trendline type. Read/write XlTrendlineType.