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

Office 2007
Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. 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

Community Additions