Click or drag to resize

IChartSerie Properties

The IChartSerie type exposes the following members.

Properties
Name Description
Public property Code example Bubbles
Bubble sizes for the series.
Examples
The following code illustrates how to set Bubbles for IChartSerie in charts:
Copy 
<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 serie</para><para>IChartSerie serie = chart.Series.Add(ExcelChartType.Bubble);</para><para>//Set values and bubble chart range</para><para>serie.Values = worksheet.Range["A1:C1"];;</para><para>serie.Bubbles = worksheet.Range["A2:C2"];</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example CategoryLabels
Category labels for the series.
Examples
The following code illustrates how to set category labels for IChartSerie in charts:
Copy 
<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 serie</para><para>IChartSerie serie = chart.Series.Add();</para><para>//Set category labels and values</para><para>serie.CategoryLabels = worksheet.Range["A1:C1"];</para><para>serie.Values = worksheet.Range["A2:C2"];</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property DataLabels
Gets the data labels associated with the chart.
Public property Code example DataPoints
Returns collection of data points. Read-only.
Examples
The following code illustrates how to access the IChartDataPoints collection from IChartSerie:
Copy 
<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["A1:C3"];</para><para>//Set data points</para><para>IChartDataPoints dataPoints = chart.Series[0].DataPoints;</para><para>//Set data labels value visibility</para><para>dataPoints.DefaultDataPoint.DataLabels.HasValue = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example EnteredDirectlyBubbles
Represents bubble values as entered directly.
Examples
The following code illustrates how series data for second value axis of ExcelChartType.Bubble charts can be directly given for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>IChart chart = worksheet.Charts.Add();</para><para>//Set serie</para><para>IChartSerie serie = chart.Series.Add(ExcelChartType.Bubble);</para><para>//Set direct values</para><para>serie.EnteredDirectlyValues = new object[] { 10, 20, 30 };</para><para>//Set bubble chart direct values</para><para>serie.EnteredDirectlyBubbles = new object[] { 1, 4, 2 };</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example EnteredDirectlyCategoryLabels
Represents category values as entered directly.
Examples
The following code illustrates how series category labels can be directly given for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>IChart chart = worksheet.Charts.Add();</para><para>//Set serie</para><para>IChartSerie serie = chart.Series.Add(ExcelChartType.Pie);</para><para>//Set direct values</para><para>serie.EnteredDirectlyValues = new object[] { 2000, 1000, 1000 };</para><para>//Set direct category label</para><para>serie.EnteredDirectlyCategoryLabels = new object[] { "Total Income", "Expenses", "Profit" };</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example EnteredDirectlyValues
Represents value as entered directly.
Examples
The following code illustrates how series data can be directly given for charts:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create chart</para><para>IChart chart = worksheet.Charts.Add();</para><para>//Set serie</para><para>IChartSerie serie = chart.Series.Add(ExcelChartType.Pie);</para><para>//Set direct values</para><para>serie.EnteredDirectlyValues = new object[] { 2000, 1000, 1000 };</para><para>//Set direct category label</para><para>serie.EnteredDirectlyCategoryLabels = new object[] { "Total Income", "Expenses", "Profit" };</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example ErrorBarsX
Represents X error bars. Read only.
Examples
The following code illustrates how IChartErrorBars in X-axis can be accessed:
Copy 
<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].HasErrorBarsX = true;</para><para>IChartErrorBars errorBar = chart.Series[0].ErrorBarsX;</para><para>//Set error bar type</para><para>errorBar.Type = ErrorBarType.Percentage;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example ErrorBarsY
Represents Y error bars. Read only.
Examples
The following code illustrates how IChartErrorBars on Y-axis can be accessed:
Copy 
<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].HasErrorBarsY = true;</para><para>IChartErrorBars errorBar = chart.Series[0].ErrorBarsY;</para><para>//Set error bar type</para><para>errorBar.Type = ErrorBarType.Percentage;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example Format
Returns format of current serie.
Examples
The following code illustrates how to access the IChartSerieDataFormat from IChartSerie:
Copy 
<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["A1:C2"];</para><para>//Set chart type</para><para>chart.ChartType = ExcelChartType.Line;</para><para>//Set serie format</para><para>IChartSerieDataFormat format = chart.Series[0].Format;</para><para>//Set marker style</para><para>format.MarkerStyle = ChartMarkerType.Star;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example HasErrorBarsX
Indicates if serie contains X error bars.
Examples
The following code illustrates how HasErrorBarsX property can be used:
Copy 
<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].HasErrorBarsX = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example HasErrorBarsY
Indicates if serie contains Y error bars.
Examples
The following code illustrates how HasErrorBarsY property can be used:
Copy 
<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].HasErrorBarsY = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example Name
Name of the series.
Examples
The following code illustrates how to access the name of the IChartSerie:
Copy 
<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 serie</para><para>IChartSerie serie = chart.Series.Add("BarSerie");</para><para>//Set category labels and values</para><para>serie.CategoryLabels = worksheet.Range["A1:C1"];</para><para>serie.Values = worksheet.Range["A2:C2"];</para><para>//Get Serie name</para><para>Console.Write(serie.Name);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property NamedRange
Series Name range for the series.
Public property Parent
Gets the parent object of the current instance.
(Inherited from IExcelApplication .)
Public property Code example SerieType
Represents serie type.
Examples
The following code illustrates how to set SerieType for charts:
Copy 
<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["A1:C2"];</para><para>//Set chart type</para><para>chart.Series[0].SerieType = ExcelChartType.Line;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example TrendLines
Represents serie trend lines collection. Read only.
Examples
The following code illustrates how IChartTrendLines collection can be accessed from a particular IChartSerie:
Copy 
<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 trend line</para><para>IChartTrendLines trendLines = chart.Series[0].TrendLines;</para><para>IChartTrendLine trendLine = trendLines.Add(TrendLineType.Linear);</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example UsePrimaryAxis
Indicates whether to use primary axis for series drawing.
Examples
The following code illustrates how the secondary axis can be used by disabling primary axis:
Copy 
<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["A1:C3"];</para><para>//Set secondary axis</para><para>IChartSerie serie = chart.Series[1];</para><para>serie.UsePrimaryAxis = false;</para><para>chart.SecondaryCategoryAxis.Visible = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Public property Code example Values
Values range for the series.
Examples
The following code illustrates how to set values for IChartSerie in charts:
Copy 
<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 serie</para><para>IChartSerie serie = chart.Series.Add();</para><para>//Set category labels and values</para><para>serie.CategoryLabels = worksheet.Range["A1:C1"];</para><para>serie.Values = worksheet.Range["A2:C2"];</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
Top
See Also