Trendline Object Members

  • Article
Excel Developer Reference

Represents a trendline in a chart.

Methods

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

Properties

  Name Description
Bb225736.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel 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.
Bb225736.properties(en-us,office.12).gif Backward Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Read/write Long
Bb225736.properties(en-us,office.12).gif Backward2 Read/write
Bb225736.properties(en-us,office.12).gif Border Returns a Border object that represents the border of the object.
Bb225736.properties(en-us,office.12).gif DataLabel Returns a DataLabel object that represents the data label associated with the trendline. Read-only.
Bb225736.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). Setting this property to True automatically turns on data labels. Read/write Boolean.
Bb225736.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). Setting this property to True automatically turns on data labels. Read/write Boolean.
Bb225736.properties(en-us,office.12).gif Format Read-only
Bb225736.properties(en-us,office.12).gif Forward Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. Read/write Long.
Bb225736.properties(en-us,office.12).gif Forward2 Read/write
Bb225736.properties(en-us,office.12).gif Index Returns a Long value that represents the index number of the object within the collection of similar objects.
Bb225736.properties(en-us,office.12).gif Intercept Returns or sets the point where the trendline crosses the value axis. Read/write Double.
Bb225736.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.
Bb225736.properties(en-us,office.12).gif Name Returns or sets a String value representing the name of the object.
Bb225736.properties(en-us,office.12).gif NameIsAuto True if Microsoft Excel automatically determines the name of the trendline. Read/write Boolean.
Bb225736.properties(en-us,office.12).gif Order Returns or sets a Long value that represents the trendline order (an integer greater than 1) when the trendline type is xlPolynomial.
Bb225736.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225736.properties(en-us,office.12).gif Period Read/write
Bb225736.properties(en-us,office.12).gif Type Returns or sets a XlTrendlineType value that represents the trendline type.