IChartSerie ErrorBar Method |
Overload List
| Name | Description | |
|---|---|---|
|
ErrorBar(Boolean) |
Creates error bar object.
Examples
The following code illustrates how to set IChartErrorBars on Y-axis of a
particular IChartSerie:
<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>//Set range</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set error bar</para><para>chart.Series[0].ErrorBar(true);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
ErrorBar(Boolean, ErrorBarIncludeType) |
Creates error bar object.
Examples
The following code illustrates how to set IChartErrorBars with
ErrorBarIncludeType.Plus on Y-axis of a particular IChartSerie:
<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>//Set range</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set error bar</para><para>chart.Series[0].ErrorBar(true, ErrorBarIncludeType.Plus);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
ErrorBar(Boolean, IXLSRange, IXLSRange) |
Sets custom error bar type.
Examples
The following code illustrates how an IChartErrorBars can be created on X-axis
with IChartErrorBars.PlusRange and IChartErrorBars.MinusRange:
<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>//Set chart type</para><para>chart.ChartType = ExcelChartType.ScatterLine;</para><para>//Set range</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set error bar</para><para>chart.Series[0].ErrorBar(false, worksheet.Range["A3"], worksheet.Range["B3"]);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
ErrorBar(Boolean, ErrorBarIncludeType, ErrorBarType) |
Creates error bar object.
Examples
The following code illustrates how to set IChartErrorBars with ErrorBarIncludeType.Plus
and ErrorBarType.Percentage on Y-axis of a particular IChartSerie:
<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>//Set range</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set error bar</para><para>chart.Series[0].ErrorBar(true, ErrorBarIncludeType.Plus, ErrorBarType.Percentage);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
|
|
ErrorBar(Boolean, ErrorBarIncludeType, ErrorBarType, Double) |
Creates error bar object.
Examples
The following code illustrates how to set IChartErrorBars with ErrorBarIncludeType.Plus ,
ErrorBarType.Percentage and number value of "50" on Y-axis of a particular IChartSerie:
<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>//Set range</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set error bar</para><para>chart.Series[0].ErrorBar(true, ErrorBarIncludeType.Plus, ErrorBarType.Percentage, 50);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
|
See Also
