- 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.Intercept
Intercept Property
Intercept
Gets or sets the point where the trendline crosses the value axis.
Returns the fixed intercept value when the trendline intercept has been set explicitly.
Declaration
double Intercept { get; set; }Property Intercept As DoubleExamples
worksheet.Range["A1:B5"].Value = new object[,] {
{1, 2},
{2, 4},
{3, 6},
{4, 8},
{5, 10}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.XYScatter, 20, 20, 300, 200).Chart;
chart.SourceData = worksheet.Range["A1:B5"];
ITrendline trendline = chart.SeriesCollection[0].Trendlines.Add();
trendline.Intercept = 1.5;
double intercept = trendline.Intercept;