Name | Description | |
---|---|---|
clearFormats | Clears the formatting of the object. | |
delete | Deletes the object. | |
getBackward | Gets the number of periods (or units on a scatter chart) that the trendline extends backward. | |
getDataLabel | Returns a IDataLabel object that represents the data label associated with the trendline. | |
getDisplayEquation | Gets whether to display the equation for the trendline (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. | |
getDisplayRSquared | Gets whether to display the R-squared value (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. | |
getFormat | Returns the format for chart elements. | |
getForward | Gets the number of periods (or units on a scatter chart) that the trendline extends forward. | |
getIndex | Returns the index number of the object within the collection of similar objects. | |
getIntercept | Gets the point where the trendline crosses the value axis. | |
getName | Gets the name of the object. | |
getNameIsAuto | Gets if the trendline's name is automatically determined. | |
getOrder | Gets the trendline order (an integer greater than 1) when the trendline type is Polynomial. | |
getParent | Returns the parent object for the specified object. | |
getPeriod | Gets the period for the moving-average trendline. | |
getType | Gets the trendline type. | |
setBackward | Sets the number of periods (or units on a scatter chart) that the trendline extends backward. | |
setDisplayEquation | Sets whether to display the equation for the trendline (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. | |
setDisplayRSquared | Sets whether to display the R-squared value (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. | |
setForward | Sets the number of periods (or units on a scatter chart) that the trendline extends forward. | |
setIntercept | Sets the point where the trendline crosses the value axis. | |
setName | Sets the name of the object. | |
setNameIsAuto | Sets if the trendline's name is automatically determined. | |
setOrder | Sets the trendline order (an integer is greater than or equal to 2 and less than or equal to 6) when the trendline type is Polynomial. | |
setPeriod | Sets the period for the moving-average trendline. | |
setType | Sets the trendline type. |