TrendLines (Collections)

Member of:

ChartSection object

Description

Represents a collection of trend line used to track trends in a data series graphically.

For this collection, the Add (Method) creates and adds a fact-bound reference line. The FactIndex is the index of the fact in the Fact array (1 for axis-bound reference lines). Axis – should be passed for axis-bound reference lines and for Scatter/Bubble charts.

Example:

This example shows how to add a trend line using the fact index value for Amount Sales:

ActiveDocument.Sections["Chart"].TrendLines.Add(1)

Methods:

Add(FactNameOrIndex as value, [optional] axis as BqChartAxisType), Item (Index as number), Remove (Index as number), RemoveAll

Properties:

Read only: Count as Number

Objects:

TrendLine object