Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Trendline.Forward2 Property

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

Version Information
 Version Added:  Excel 2007

Syntax

expression.Forward2

expression   A variable that represents a Trendline object.

Example

This example sets the number of units that the trendline on Chart1 extends forward and backward. The example should be run on a 2-D column chart that contains a single series with a trendline.

Visual Basic for Applications
With Charts("Chart1").SeriesCollection(1).Trendlines(1)
    .Forward2 = 5
    .Backward2 = .5
End With



Show: