[]
Gets or sets the number of periods, or units on a scatter chart, that the trendline extends forward.
Use this property to read the forecast length configured for the trendline. For scatter charts, the returned value represents units on the horizontal axis rather than category periods.
double Forward { get; set; }
Property Forward As Double
worksheet.Range["A1:A4"].Value = new object[] { 10, 20, 30, 40 };
IShape shape = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 220);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:A4"], RowCol.Columns);
ITrendline trendline = shape.Chart.SeriesCollection[0].Trendlines.Add();
trendline.Forward = 1.5;
double forward = trendline.Forward;