Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Trendline Properties 

  Name Description
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.
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.
Forward Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward.
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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.