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. |