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

Syntax

expression.Backward2

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



Community Additions

Show:
© 2015 Microsoft