Series Class

Encapsulates the object that represents a single data series in a chart.
Inheritance Hierarchy
SystemObject
  Aspose.Cells.ChartsSeries

Namespace:  Aspose.Cells.Charts
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.10.0.0 (20.10)
Syntax
public class Series

The Series type exposes the following members.

Properties
  NameDescription
Public propertyArea
Represents the background area of Series object.
Public propertyBar3DShapeType
Gets or sets the 3D shape type used with the 3-D bar or column chart.
Public propertyBarShape Obsolete.
Gets or sets the 3D shape type used with the 3-D bar or column chart.
Public propertyBorder
Represents border of Series object.
Public propertyBubbleScale
Gets or sets the scale factor for bubbles in the specified chart group. It can be an integer value from 0 (zero) to 300, corresponding to a percentage of the default size. Applies only to bubble charts.
Public propertyBubbleSizes
Gets or sets the bubble sizes values of the chart series.
Public propertyCountOfDataValues
Gets the number of the data values.
Public propertyDataLabels
Represents the DataLabels object for the specified ASeries.
Public propertyDisplayName
Gets the series's name that displays on the chart graph.
Public propertyDoughnutHoleSize
Returns or sets the size of the hole in a doughnut chart group. The hole size is expressed as a percentage of the chart size, between 10 and 90 percent.
Public propertyDownBars
Returns a DropBars object that represents the down bars on a line chart. Applies only to line charts.
Public propertyDropLines
Returns a Line object that represents the drop lines for a series on the line chart or area chart. Applies only to line chart or area charts.
Public propertyExplosion
The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.
Public propertyFirstSliceAngle
Gets or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts, 0 to 360.
Public propertyGapWidth
Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500.
Public propertyHas3DEffect
True if the series has a three-dimensional appearance. Applies only to bubble charts.
Public propertyHasDropLines
True if the chart has drop lines. Applies only to line chart or area charts.
Public propertyHasHiLoLines
True if the line chart has high-low lines. Applies only to line charts.
Public propertyHasLeaderLines
True if the series has leader lines.
Public propertyHasRadarAxisLabels
True if a radar chart has category axis labels. Applies only to radar charts.
Public propertyHasSeriesLines
True if a stacked column chart or bar chart has series lines or if a Pie of Pie chart or Bar of Pie chart has connector lines between the two sections. Applies only to stacked column charts, bar charts, Pie of Pie charts, or Bar of Pie charts.
Public propertyHasUpDownBars
True if a line chart has up and down bars. Applies only to line charts.
Public propertyHiLoLines
Returns a HiLoLines object that represents the high-low lines for a series on a line chart. Applies only to line charts.
Public propertyIsAutoSplit
Indicates whether the threshold value is automatic.
Public propertyIsColorVaried
Represents if the color of points is varied. The chart must contain only one series.
Public propertyIsVerticalValues
Indicates whether the data source is vertical.
Public propertyLayoutProperties
Represents the properties of layout.
Public propertyLeaderLines
Represents leader lines on a chart. Leader lines connect data labels to data points. This object isn¡¯t a collection; there¡¯s no object that represents a single leader line.
Public propertyLegendEntry
Gets the legend entry according to this series.
Public propertyMarker
Gets the marker.
Public propertyMarkerBackgroundColor Obsolete.
Represents the marker background color in a line chart, scatter chart, or radar chart.
Public propertyMarkerBackgroundColorSetType Obsolete.
Gets or sets the marker background color set type.
Public propertyMarkerForegroundColor Obsolete.
Represents the marker foreground color in a line chart, scatter chart, or radar chart.
Public propertyMarkerForegroundColorSetType Obsolete.
Gets or sets the marker foreground color set type.
Public propertyMarkerSize Obsolete.
Represents the marker size in a line chart, scatter chart, or radar chart.
Public propertyMarkerStyle Obsolete.
Represents the marker style in a line chart, scatter chart, or radar chart.
Public propertyCode exampleName
Gets or sets the name of the data series.
Public propertyOverlap
Specifies how bars and columns are positioned. Can be a value between ¨C 100 and 100. Applies only to 2-D bar and 2-D column charts.
Public propertyPlotOnSecondAxis
Indicates if this series is plotted on second value axis.
Public propertyPoints
Gets the collection of points in a series in a chart.
Public propertySecondPlotSize
Returns or sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie. Can be a value from 5 to 200.
Public propertySeriesLines
Returns a SeriesLines object that represents the series lines for a stacked bar chart or a stacked column chart. Applies only to stacked bar and stacked column charts.
Public propertyShadow
True if the series has a shadow.
Public propertyShapeProperties
Gets the object that holds the visual shape properties of the Series.
Public propertyShowNegativeBubbles
True if negative bubbles are shown for the chart group. Valid only for bubble charts.
Public propertySizeRepresents
Gets or sets what the bubble size represents on a bubble chart.
Public propertySmooth
Represents curve smoothing. True if curve smoothing is turned on for the line chart or scatter chart. Applies only to line and scatter connected by lines charts.
Public propertySplitType
Returns or sets a value that how to determine which data points are in the second pie or bar on a pie of pie or bar of pie chart.
Public propertySplitValue
Returns or sets a value that shall be used to determine which data points are in the second pie or bar on a pie of pie or bar of pie chart.
Public propertyTrendLines
Returns an object that represents a collection of all the trendlines for the series.
Public propertyType
Gets or sets a data series' type.
Public propertyUpBars
Returns an DropBars object that represents the up bars on a line chart. Applies only to line charts.
Public propertyValues
Represents the data of the chart series.
Public propertyValuesFormatCode
Represents format code of Values¡®s NumberList.
Public propertyXErrorBar
Represents X direction error bar of the series.
Public propertyXValues
Represents the x values of the chart series.
Public propertyYErrorBar
Represents Y direction error bar of the series.
Methods
  NameDescription
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodMove
Moves the series up or down.
Public methodToString (Inherited from Object.)
Examples
[C#]

//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Adding a new worksheet to the Excel object
int sheetIndex = workbook.Worksheets.Add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[sheetIndex];
//Adding a sample value to "A1" cell
worksheet.Cells["A1"].PutValue(50);
//Adding a sample value to "A2" cell
worksheet.Cells["A2"].PutValue(100);
//Adding a sample value to "A3" cell
worksheet.Cells["A3"].PutValue(150);
//Adding a sample value to "A4" cell
worksheet.Cells["A4"].PutValue(200);
//Adding a sample value to "B1" cell
worksheet.Cells["B1"].PutValue(60);
//Adding a sample value to "B2" cell
worksheet.Cells["B2"].PutValue(32);
//Adding a sample value to "B3" cell
worksheet.Cells["B3"].PutValue(50);
//Adding a sample value to "B4" cell
worksheet.Cells["B4"].PutValue(40);
//Adding a sample value to "C1" cell as category data
worksheet.Cells["C1"].PutValue("Q1");
//Adding a sample value to "C2" cell as category data
worksheet.Cells["C2"].PutValue("Q2");
//Adding a sample value to "C3" cell as category data
worksheet.Cells["C3"].PutValue("Y1");
//Adding a sample value to "C4" cell as category data
worksheet.Cells["C4"].PutValue("Y2");
//Adding a chart to the worksheet
int chartIndex = worksheet.Charts.Add(ChartType.Column, 5, 0, 15, 5);
//Accessing the instance of the newly added chart
Chart chart = worksheet.Charts[chartIndex];
//Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B4"
chart.NSeries.Add("A1:B4", true);
//Setting the data source for the category data of NSeries
chart.NSeries.CategoryData = "C1:C4";
Series series = chart.NSeries[1];
//Setting the values of the series.
series.Values = "=B1:B4";
//Changing the chart type of the series.
series.Type = ChartType.Line;
//Setting marker properties.
series.MarkerStyle = ChartMarkerType.Circle;
series.MarkerForegroundColorSetType = FormattingType.Automatic;
series.MarkerForegroundColor = System.Drawing.Color.Black;
series.MarkerBackgroundColorSetType = FormattingType.Automatic;
//Saving the Excel file
workbook.Save("C:\\book1.xls");

[Visual Basic]

'Instantiating a Workbook object
Dim workbook As Workbook = New Workbook()
'Adding a new worksheet to the Excel object
Dim sheetIndex As Int32 = workbook.Worksheets.Add()
'Obtaining the reference of the newly added worksheet by passing its sheet index
Dim worksheet As Worksheet = workbook.Worksheets(sheetIndex)
'Adding a sample value to "A1" cell
worksheet.Cells("A1").PutValue(50)
'Adding a sample value to "A2" cell
worksheet.Cells("A2").PutValue(100)
'Adding a sample value to "A3" cell
worksheet.Cells("A3").PutValue(150)
'Adding a sample value to "A4" cell
worksheet.Cells("A4").PutValue(200)
'Adding a sample value to "B1" cell
worksheet.Cells("B1").PutValue(60)
'Adding a sample value to "B2" cell
worksheet.Cells("B2").PutValue(32)
'Adding a sample value to "B3" cell
worksheet.Cells("B3").PutValue(50)
'Adding a sample value to "B4" cell
worksheet.Cells("B4").PutValue(40)
'Adding a sample value to "C1" cell as category data
worksheet.Cells("C1").PutValue("Q1")
'Adding a sample value to "C2" cell as category data
worksheet.Cells("C2").PutValue("Q2")
'Adding a sample value to "C3" cell as category data
worksheet.Cells("C3").PutValue("Y1")
'Adding a sample value to "C4" cell as category data
worksheet.Cells("C4").PutValue("Y2")
'Adding a chart to the worksheet
Dim chartIndex As Int32 = worksheet.Charts.Add(ChartType.Column, 5, 0, 15, 5)
'Accessing the instance of the newly added chart
Dim chart As Chart = worksheet.Charts(chartIndex)
'Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B4"
chart.NSeries.Add("A1:B4", True)
'Setting the data source for the category data of NSeries
chart.NSeries.CategoryData = "C1:C4"
Dim series As Series = chart.NSeries(1)
'Setting the values of the series.
series.Values = "=B1:B4"
'Changing the chart type of the series.
series.Type = ChartType.Line
'Setting marker properties.
series.MarkerStyle = ChartMarkerType.Circle
series.MarkerForegroundColorSetType = FormattingType.Automatic
series.MarkerForegroundColor = System.Drawing.Color.Black
series.MarkerBackgroundColorSetType = FormattingType.Automatic
'Saving the Excel file
workbook.Save("C:\\book1.xls")
See Also