Trendline Properties

Name

Returns

Description

Backward

Long

Set/Get how many periods the trendline extends back

Backward2

Double

Set/Get how many periods the trendline extends back

Border

Border

Read-only. Returns the border's properties around the trendline

DataLabel

DataLabel

Read-only. Returns an object to manipulate the trendline's data label

Display Equation

Boolean

Set/Get whether the equation used for the trendline is displayed on the chart

Display RSquared

Boolean

Set/Get whether the R-squared value for the trendline is displayed on the chart

Format

ChartFormat

Returns the ChartFormat object, which controls the line and effect formatting for the trendline

Forward2

Double

Set/Get how many periods the trendline extends forward

Index

Long

Read-only. Returns the spot in the collection where the current object is

Intercept

Double

Set/Get at which point the trendline crosses the value (y) axis

InterceptIs Auto

Boolean

Set/Get whether the point at which the trendline crosses the value axis is automatically calculated with regression

Name

String

Set/Get the name of the Trendline object

NameIsAuto

Boolean

Set/Get whether Excel automatically chooses the trendline name

Order

Long

Set/Get the order of a polynomial trendline. The Type property must be xlPolynomial

Period

Long

Set/Get what the period is for the moving-average trendline

Type

XlTrendline Type

Set/Get the type of the trendline (for example, xlExponential, xlLinear, and so on)

ndline Methods

Name

Returns

Description

ClearFormats

Variant

Clears any formatting made on the trendlines

Delete

Variant

Deletes the trendlines

Select

Variant

Selects the trendlines on the chart

Was this article helpful?

0 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Post a comment