Skip to content

Latest commit

 

History

History
40 lines (25 loc) · 942 Bytes

Excel.Trendline.Forward2.md

File metadata and controls

40 lines (25 loc) · 942 Bytes
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Trendline.Forward2 property (Excel)
vbaxl10.chm594092
vbaxl10.chm594092
Excel.Trendline.Forward2
af44bce5-8354-801e-f111-6adcb305b06b
05/18/2019
medium

Trendline.Forward2 property (Excel)

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

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 2D column chart that contains a single series with a trendline.

With Charts("Chart1").SeriesCollection(1).Trendlines(1) 
 .Forward2 = 5 
 .Backward2 = .5 
End With

[!includeSupport and feedback]