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



expression   A variable that represents a Trendline object.


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