Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Backward Property

Office 2007

Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Read/write Long.


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

With myChart.SeriesCollection(1).Trendlines(1)
    .Forward = 5
    .Backward = .5
End With

See Also

© 2015 Microsoft