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

Figure 17-6. Use this dialog to browse trendline settings
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access