Export (0) Print
Expand All

Trendline Members (Word)

Represents a trendline in a chart.

Name

Description

ClearFormats

Clears the formatting of the object.

Delete

Deletes the object.

Select

Selects the object.

Name

Description

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.

Backward2

Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Read/write Double.

Border

Returns the border of the object. Read-only ChartBorder.

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

DataLabel

Returns the data label that is associated with the trendline. Read-only DataLabel.

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.

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.

Format

Returns the line, fill, and effect formatting for the object. Read-only ChartFormat.

Forward2

Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. Read/write Double.

Index

Returns the index number of the object within the collection of similar objects. Read-only Long.

Intercept

Returns or sets the point where the trendline crosses the value axis. Read/write Double.

InterceptIsAuto

True if the point where the trendline crosses the value axis is automatically determined by the regression. Read/write Boolean.

Name

Returns or sets name of the object. Read/write String.

NameIsAuto

True if Microsoft Word automatically determines the name of the trendline. Read/write Boolean.

Order

Returns or sets the trendline order (an integer greater than 1) when the trendline type is xlPolynomial. Read/write Long.

Parent

Returns the parent for the specified object. Read-only Object.

Period

Returns or sets the period for the moving-average trendline. Read/write Long.

Type

Returns or sets the trendline type. Read/write XlTrendlineType.

Community Additions

ADD
Show:
© 2014 Microsoft