- DsExcel .NET API Overview
-
DS.Documents.Excel Assembly
- GrapeCity.Documents.Excel
-
GrapeCity.Documents.Excel.Drawing
- Enums
-
Interfaces
- IAdjustments
- IAxes
- IAxis
- IAxisTitle
- IBackgroundPicture
- IBackgroundPictures
- IChart
- IChartArea
- IChartBars
- IChartFormat
- IChartGroup
- IChartGroups
- IChartLines
- IChartTitle
- IColorFormat
- IConnectorFormat
- IContainer
- ICrop
- IDataLabel
- IDataLabels
- IDataTable
- IDisplayUnitLabel
- IErrorBar
- IFillFormat
- IFloor
- IFontFormat
- IGradientStop
- IGradientStops
- IGridlines
- IGroupShapes
- ILegend
- ILegendEntries
- ILegendEntry
- ILineFormat
- IPictureFormat
- IPivotOptions
- IPlotArea
- IPoint
- IPoints
- ISeries
- ISeriesCollection
- IShape
- IShapeRange
- IShapeRangeProvider
- IShapes
- ITextFrame
- ITextRange
- IThreeDFormat
- ITickLabels
- ITrendline
- ITrendlines
- IWall
- GrapeCity.Documents.Excel.Expressions
- GrapeCity.Documents.Excel.Forms
GrapeCity.Documents.Excel.Drawing.ITrendline.Backward
Backward Property
Backward
Gets or sets the number of periods, or units on a scatter chart, that the trendline extends backward.
Use this property to read the backward forecast length configured for the trendline. For scatter charts, the returned value represents units on the horizontal axis rather than category periods.
Declaration
double Backward { get; set; }Property Backward As DoubleExamples
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.Backward = 0.5;
double backward = trendline.Backward;