IChartTrendLine Properties |
The IChartTrendLine type exposes the following members.
Name | Description | |
---|---|---|
![]() ![]() |
Backward |
Represents number of periods that the trendline extends backward.
![]()
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>
|
![]() ![]() |
Border |
Represents border object. Read only.
![]()
The following code illustrates how to access and format the IChartBorder for IChartTrendLine:
<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>IChart chart = worksheet.Charts.Add();</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>//Get chart trendlines collection</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>//Add trendline</para><para>IChartTrendLine trendline = trendLines.Add();</para><para>//Set trendline broder properties</para><para>trendline.Border.Color = Color.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() |
Chart3DOptions |
Gets the IThreeDFormat object. Read-only.[Deprecated]
|
![]() ![]() |
DataLabel |
Returns data label. Read only.
![]()
The following code illustrates how to enable and set IChartTextArea text 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 and Get chart serie</para><para>Chart chart = worksheet.Charts.Add(ExcelChartType.ColumnClustered);</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>IChartSerie serie = chart.Series[0];</para><para>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add();</para><para>//Enable trendline data label by DisplayRSquared</para><para>trendline.DisplayRSquared = true;</para><para>//Set data label text</para><para>trendline.DataLabel.Text = "y=10*x";</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() ![]() |
DisplayEquation |
True if the equation for the trendline is displayed on the chart.
![]()
The following code illustrates how to display equation 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 and Get chart serie</para><para>Chart chart = worksheet.Charts.Add(ExcelChartType.ColumnClustered);</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>IChartSerie serie = chart.Series[0];</para><para>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add();</para><para>//Set equation in trendline</para><para>trendline.DisplayEquation = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() ![]() |
DisplayRSquared |
True if the R-squared value of the trendline is displayed on the chart.
![]()
The following code illustrates how to display RSquared 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 and Get chart serie</para><para>Chart chart = worksheet.Charts.Add(ExcelChartType.ColumnClustered);</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>IChartSerie serie = chart.Series[0];</para><para>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add();</para><para>//Set RSquared value for trendline</para><para>trendline.DisplayRSquared = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() |
Formula |
Return trendline formula. Read only.
|
![]() ![]() |
Forward |
Represents number of periods that the trendline extends forward.
![]()
The following code illustrates how to set Forward 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.Forward = 3;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() ![]() |
Intercept |
Represents point where the trendline crosses the value axis.
![]()
The following code illustrates how to set intercept 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>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add();</para><para>//Set intercept value</para><para>trendline.Intercept = 10;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() ![]() |
InterceptIsAuto |
True if the point where the trendline crosses the value
axis is automatically determined by the regression.
![]()
The following code illustrates how to check whether the IChartTrendLine object
intercept value is automatic or not:
<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>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add();</para><para>//Set intercept value</para><para>trendline.Intercept = 10;</para><para>//Check trendline intercept is automatic</para><para>Console.WriteLine("Is Trendline Intercept value is automatic:" + trendline.InterceptIsAuto.ToString());</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() ![]() |
Name |
Represents trendline name.
![]()
The following code illustrates how to access name from 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 and Get chart serie</para><para>Chart chart = worksheet.Charts.Add(ExcelChartType.ColumnClustered);</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>IChartSerie serie = chart.Series[0];</para><para>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add(TrendLineType.Logarithmic);</para><para>//Get trendline Name</para><para>Console.WriteLine(trendline.Name);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() ![]() |
NameIsAuto |
Indicates if name is default.
![]()
The following code illustrates how to check whether the IChartTrendLine object name is default or not:
<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 and Get chart serie</para><para>Chart chart = worksheet.Charts.Add(ExcelChartType.ColumnClustered);</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>IChartSerie serie = chart.Series[0];</para><para>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add(TrendLineType.Logarithmic);</para><para>//Set trendline name</para><para>trendline.Name = "Trendline 1";</para><para>//Check trendline name is automatic</para><para>Console.WriteLine(trendline.NameIsAuto);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() ![]() |
Order |
Represents for Moving Averange and Polynomial trend line type order value.
![]()
The following code illustrates how to set order 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.ColumnClustered);</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>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add();</para><para>//Set trendline type</para><para>trendline.Type = TrendLineType.Polynomial;</para><para>//Set trendline order</para><para>trendline.Order = 6;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() ![]() |
Shadow |
Gets the shadow.Read-only.
![]()
The following code illustrates how to access and format the IShadow for IChartTrendLine:
<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>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add();</para><para>//Set trendline shadow color</para><para>trendline.Shadow.Color = Color.Red;</para><para>//Set trendline shadow outer presets</para><para>trendline.Shadow.ShadowOuterType = XLSXChartShadowOuterType.OffsetDiagonalTopRight;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
![]() ![]() |
Type |
Represents trend line type.
![]()
The following code illustrates how to set TrendLineType 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 and Get chart serie</para><para>Chart chart = worksheet.Charts.Add(ExcelChartType.ColumnClustered);</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>IChartSerie serie = chart.Series[0];</para><para>//Get chart trendlines collection and Add trendline</para><para>IChartTrendLines trendLines = serie.TrendLines;</para><para>IChartTrendLine trendline = trendLines.Add();</para><para>//Set trendline type</para><para>trendline.Type = TrendLineType.Polynomial;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|