IChartErrorBars Interface |
Represent error bars on the chart series.
Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line,
and scatter groups on a 2-D chart can have error bars.
Only series in scatter groups can have x and y error bars.
Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The IChartErrorBars type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
Border |
Represents border object. Read only.
Examples
The following code illustrates how to access and format the IChartBorder for IChartErrorBars:
<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 set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Get chart serie</para><para>IChartSerie serie = chart.Series[0];</para><para>//Enabling the Y Error bars</para><para>serie.ErrorBar(true,ErrorBarIncludeType.Both,ErrorBarType.Percentage,10);</para><para>IChartErrorBars errorBars = serie.ErrorBarsY;</para><para>//Set Error bars border color</para><para>errorBars.Border.Color = Color.Red;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
Chart3DOptions |
Gets the chart3 D options.
|
|
|
HasCap |
Indicates if error bar has cap.
Examples
The following code illustrates how to remove end style for IChartErrorBars:
<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 set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Get chart serie</para><para>IChartSerie serie = chart.Series[0];</para><para>//Enabling the Y Error bars</para><para>serie.ErrorBar(true,ErrorBarIncludeType.Both,ErrorBarType.Percentage,10);</para><para>IChartErrorBars errorBars = serie.ErrorBarsY;</para><para>//Set false to remove the end style</para><para>errorBars.HasCap = false;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
Include |
Reprsents error bar include type.
Examples
The following code illustrates how to set include type for IChartErrorBars:
<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 set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Get chart serie</para><para>IChartSerie serie = chart.Series[0];</para><para>//Enabling the Y Error bars</para><para>serie.ErrorBar(true,ErrorBarIncludeType.Both,ErrorBarType.Percentage,10);</para><para>IChartErrorBars errorBars = serie.ErrorBarsY;</para><para>//Set negative error only to include</para><para>errorBars.Include = ErrorBarIncludeType.Minus;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
MinusRange |
Represents custom minus value.
Examples
The following code illustrates how to set the minus range for IChartErrorBars:
<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 set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Get chart serie</para><para>IChartSerie serie = chart.Series[0];</para><para>//Enabling the Y Error bars</para><para>serie.ErrorBar(true,ErrorBarIncludeType.Both,ErrorBarType.Percentage,10);</para><para>IChartErrorBars errorBars = serie.ErrorBarsY;</para><para>//Set minus range</para><para>errorBars.MinusRange = worksheet["D2"];</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
NumberValue |
Represents number value.
Examples
The following code illustrates how to set the error value for IChartErrorBars:
<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 set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Get chart serie</para><para>IChartSerie serie = chart.Series[0];</para><para>//Enabling the Y Error bars</para><para>serie.ErrorBar(true,ErrorBarIncludeType.Both,ErrorBarType.Percentage,10);</para><para>IChartErrorBars errorBars = serie.ErrorBarsY;</para><para>//Set error value</para><para>errorBars.NumberValue = 3.0;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
PlusRange |
Represents custom plus value.
Examples
The following code illustrates how to set the plus range for IChartErrorBars:
<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 set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Get chart serie</para><para>IChartSerie serie = chart.Series[0];</para><para>//Enabling the Y Error bars</para><para>serie.ErrorBar(true,ErrorBarIncludeType.Both,ErrorBarType.Percentage,10);</para><para>IChartErrorBars errorBars = serie.ErrorBarsY;</para><para>//Set plus range</para><para>errorBars.PlusRange = worksheet["D2"];</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
Shadow |
Gets the shadow.
Examples
The following code illustrates how to access and format the IShadow for IChartErrorBars:
<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 set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Get chart serie</para><para>IChartSerie serie = chart.Series[0];</para><para>//Enabling the Y Error bars</para><para>serie.ErrorBar(true,ErrorBarIncludeType.Both,ErrorBarType.Percentage,10);</para><para>IChartErrorBars errorBars = serie.ErrorBarsY;</para><para>//Set Error bars shadow color</para><para>errorBars.Shadow.Color = Color.Red;</para><para>//Set Error bars shadow outer presets</para><para>errorBars.Shadow.ShadowOuterType = XLSXChartShadowOuterType.OffsetDiagonalTopRight;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
Type |
Represents excel error bar type.
Examples
The following code illustrates how to set the error bar type for IChartErrorBars:
<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 set range</para><para>IChart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C3"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.ColumnClustered;</para><para>//Get chart serie</para><para>IChartSerie serie = chart.Series[0];</para><para>//Enabling the Y Error bars</para><para>serie.ErrorBar(true,ErrorBarIncludeType.Both,ErrorBarType.Percentage,10);</para><para>IChartErrorBars errorBars = serie.ErrorBarsY;</para><para>//Set error amount to standard deviation</para><para>errorBars.Type = ErrorBarType.StandardDeviation;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
Methods
| Name | Description | |
|---|---|---|
|
ClearFormats |
Clears current error bar.
|
|
|
Delete |
Delete current error bar.
|
See Also
