Click or drag to resize

IChartTrendLine Backward Property

Represents number of periods that the trendline extends backward.
Examples
The following code illustrates how to set backward forecast value for IChartTrendLine object:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>Chart chart = worksheet.Charts.Add(ExcelChartType.ScatterMarkers);</para><para>//Add serie and set serie Y and X Values</para><para>IChartSerie serie = chart.Series.Add();</para><para>serie.Values = worksheet.Range["A2:C2"];</para><para>serie.CategoryLabels = worksheet.Range["A1:C1"];</para><para>//Set X axis minimum and maximum values</para><para>chart.PrimaryCategoryAxis.MinValue = -2;</para><para>chart.PrimaryCategoryAxis.MaxValue = 2;</para><para>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add();</para><para>//Set backward forecast value</para><para>trendline.Backward = 3;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
double Backward { get; set; }

Property Value

Type: Double
See Also