O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Trendline and Trendlines Members

Use the Trendlines collection to add trendlines to a series and to get trendlines from a series. Use the Chart object’s Trendlines property to get a reference to this collection. Use the Trendline object to control individual trendlines on the chart. The Trendlines collection and Trendline object have the following members. Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

Add 1

Application 2

Backward

Border

ClearFormats

Count 1

Creator 2

DataLabel

Delete

DisplayEquation

DisplayRSquared

Forward

Index

Intercept

InterceptIsAuto

Item 1

Name

NameIsAuto

Order

Parent 2

Period

Select

Type

 

Trendline property settings correspond to the settings on the Add Trendline dialog box (Figure 17-6). To see the dialog, right-click a series and select Add Trendline.

Use this dialog to browse trendline settings

Figure 17-6. Use this dialog to browse trendline settings

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required