Series
Series class
Encapsulates the object that represents a single data series in a chart.
Properties
| Name | Type | Description |
|---|---|---|
| IsFiltered | boolean | Indicates whether the series is selected or filtered.True represents this series is filtered, and it will not be display |
| LayoutProperties | SeriesLayoutProperties | Represents the properties of layout. |
| Points | ChartPointCollection | Gets the collection of points in a series in a chart. When the chart is Pie of Pie or Bar of Pie, the last point is othe |
| Area | Area | Represents the background area of Series object. |
| Border | Line | Represents border of Series object. |
| Name | String | Gets or sets the name of the data series. |
| DisplayName | String | Gets the series’s name that displays on the chart graph. |
| CountOfDataValues | int | Gets the number of the data values. |
| IsVerticalValues | boolean | Indicates whether the data source is vertical. |
| Values | String | Represents the Y values of this chart series. |
| CachedValues | ArrayList | |
| CachedCategoryValues | ArrayList | |
| PointValues | ChartDataValue[] | |
| CategoryValues | ChartDataValue[][] | |
| ValuesFormatCode | String | Represents format code of Values’s NumberList. |
| XValuesFormatCode | String | Represents format code of X Values’s NumberList. |
| XValues | String | Represents the x values of the chart series. |
| BubbleSizes | String | Gets or sets the bubble sizes values of the chart series. |
| TrendLines | TrendlineCollection | Returns all the trendlines of this series. |
| Smooth | boolean | Represents curve smoothing. True if curve smoothing is turned on for the line chart or scatter chart. Applies only to li |
| Shadow | boolean | True if the series has a shadow. |
| Has3DEffect | boolean | True if the series has a three-dimensional appearance. Applies only to bubble charts. |
| Bar3DShapeType | int | Gets or sets the 3D shape type used with the 3-D bar or column chart. The value of the property is Bar3DShapeType intege |
| DataLabels | DataLabels | Represents the DataLabels object for the specified ASeries. |
| Type | int | Gets or sets a data series’ type. The value of the property is ChartType integer constant. |
| Marker | Marker | Gets the Marker . |
| PlotOnSecondAxis | boolean | Indicates if this series is plotted on second value axis. |
| XErrorBar | ErrorBar | Represents X direction error bar of the series. |
| YErrorBar | ErrorBar | Represents Y direction error bar of the series. |
| HasHiLoLines | boolean | True if the line chart has high-low lines. Applies only to line charts. |
| HiLoLines | Line | Returns a HiLoLines object that represents the high-low lines for a series on a line chart. Applies only to line charts. |
| HasSeriesLines | boolean | 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 |
| SeriesLines | Line | Returns a SeriesLines object that represents the series lines for a stacked bar chart or a stacked column chart. Applies |
| HasDropLines | boolean | True if the chart has drop lines. Applies only to line chart or area charts. |
| DropLines | Line | Returns a Line object that represents the drop lines for a series on the line chart or area chart. Applies only to line |
| HasUpDownBars | boolean | True if a line chart has up and down bars. Applies only to line charts. |
| UpBars | DropBars | Returns an DropBars object that represents the up bars on a line chart. Applies only to line charts. |
| DownBars | DropBars | Returns a DropBars object that represents the down bars on a line chart. Applies only to line charts. |
| IsColorVaried | boolean | Represents if the color of points is varied. The chart must contain only one series. |
| GapWidth | int | Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this |
| FirstSliceAngle | int | Gets or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies onl |
| Overlap | int | Specifies how bars and columns are positioned. Can be a value between – 100 and 100. Applies only to 2-D bar and 2-D col |
| SecondPlotSize | int | 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 |
| SplitType | int | 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 p |
| SplitValue | float | 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 o |
| IsAutoSplit | boolean | Indicates whether the threshold value is automatic. |
| BubbleScale | int | Gets or sets the scale factor for bubbles in the specified chart group. It can be an integer value from 0 (zero) to 300, |
| SizeRepresents | int | Gets or sets what the bubble size represents on a bubble chart. The value of the property is BubbleSizeRepresents intege |
| ShowNegativeBubbles | boolean | True if negative bubbles are shown for the chart group. Valid only for bubble charts. |
| DoughnutHoleSize | int | Returns or sets the size of the hole in a doughnut chart group. The hole size is expressed as a percentage of the chart |
| Explosion | int | The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter. |
| HasRadarAxisLabels | boolean | True if a radar chart has category axis labels. Applies only to radar charts. |
| HasLeaderLines | boolean | True if the series has leader lines. |
| LeaderLines | Line | Represents leader lines on a chart. Leader lines connect data labels to data points. This object isn’t a collection; the |
| LegendEntry | LegendEntry | Gets the legend entry according to this series. |
| ShapeProperties | ShapePropertyCollection | Gets the ShapePropertyCollection object that holds the visual shape properties of the Series. |
| BubbleSizeRepresents | int | Gets what the bubble size represents on a bubble chart. The value of the property is BubbleSizeRepresents integer consta |
Methods
| Name | Description |
|---|---|
| move | Moves the series up or down. |
Series.IsFiltered property
Indicates whether the series is selected or filtered.True represents this series is filtered, and it will not be displayed on the chart.
Type: boolean
Series.LayoutProperties property
Represents the properties of layout.
Type: SeriesLayoutProperties
Series.Points property
Gets the collection of points in a series in a chart. When the chart is Pie of Pie or Bar of Pie, the last point is other point in first pie plot.
Type: ChartPointCollection
Series.Area property
Represents the background area of Series object.
Type: Area
Series.Border property
Represents border of Series object.
Type: Line
Series.Name property
Gets or sets the name of the data series.
Type: String
Series.DisplayName property
Gets the series’s name that displays on the chart graph.
Type: String
Series.CountOfDataValues property
Gets the number of the data values.
Type: int
Series.IsVerticalValues property
Indicates whether the data source is vertical.
Type: boolean
Series.Values property
Represents the Y values of this chart series.
Type: String
Series.CachedValues property
Type: ArrayList
Series.CachedCategoryValues property
Type: ArrayList
Series.PointValues property
Type: ChartDataValue[]
Series.CategoryValues property
Type: ChartDataValue[][]
Series.ValuesFormatCode property
Represents format code of Values’s NumberList.
Type: String
Series.XValuesFormatCode property
Represents format code of X Values’s NumberList.
Type: String
Series.XValues property
Represents the x values of the chart series.
Type: String
Series.BubbleSizes property
Gets or sets the bubble sizes values of the chart series.
Type: String
Series.TrendLines property
Returns all the trendlines of this series.
Type: TrendlineCollection
Series.Smooth property
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.
Type: boolean
Series.Shadow property
True if the series has a shadow.
Type: boolean
Series.Has3DEffect property
True if the series has a three-dimensional appearance. Applies only to bubble charts.
Type: boolean
Series.Bar3DShapeType property
Gets or sets the 3D shape type used with the 3-D bar or column chart. The value of the property is Bar3DShapeType integer constant.
Type: int
Series.DataLabels property
Represents the DataLabels object for the specified ASeries.
Type: DataLabels
Series.Type property
Gets or sets a data series’ type. The value of the property is ChartType integer constant.
Type: int
Series.Marker property
Gets the Marker .
Type: Marker
Series.PlotOnSecondAxis property
Indicates if this series is plotted on second value axis.
Type: boolean
Series.XErrorBar property
Represents X direction error bar of the series.
Type: ErrorBar
Series.YErrorBar property
Represents Y direction error bar of the series.
Type: ErrorBar
Series.HasHiLoLines property
True if the line chart has high-low lines. Applies only to line charts.
Type: boolean
Series.HiLoLines property
Returns a HiLoLines object that represents the high-low lines for a series on a line chart. Applies only to line charts.
Type: Line
Series.HasSeriesLines property
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.
Type: boolean
Series.SeriesLines property
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.
Type: Line
Series.HasDropLines property
True if the chart has drop lines. Applies only to line chart or area charts.
Type: boolean
Series.DropLines property
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.
Type: Line
Series.HasUpDownBars property
True if a line chart has up and down bars. Applies only to line charts.
Type: boolean
Series.UpBars property
Returns an DropBars object that represents the up bars on a line chart. Applies only to line charts.
Type: DropBars
Series.DownBars property
Returns a DropBars object that represents the down bars on a line chart. Applies only to line charts.
Type: DropBars
Series.IsColorVaried property
Represents if the color of points is varied. The chart must contain only one series.
Type: boolean
Series.GapWidth property
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.
Type: int
Series.FirstSliceAngle property
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.
Type: int
Series.Overlap property
Specifies how bars and columns are positioned. Can be a value between – 100 and 100. Applies only to 2-D bar and 2-D column charts.
Type: int
Series.SecondPlotSize property
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.
Type: int
Series.SplitType property
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. The value of the property is ChartSplitType integer constant.
Type: int
Series.SplitValue property
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.
Type: float
Series.IsAutoSplit property
Indicates whether the threshold value is automatic.
Type: boolean
Series.BubbleScale property
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.
Type: int
Series.SizeRepresents property
Gets or sets what the bubble size represents on a bubble chart. The value of the property is BubbleSizeRepresents integer constant. BubbleSizeRepresents.SizeIsArea means the value BubbleSizes is the area of the bubble. BubbleSizeRepresents.SizeIsWidth means the value BubbleSizes is the width of the bubble.
Type: int
Series.ShowNegativeBubbles property
True if negative bubbles are shown for the chart group. Valid only for bubble charts.
Type: boolean
Series.DoughnutHoleSize property
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.
Type: int
Series.Explosion property
The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.
Type: int
Series.HasRadarAxisLabels property
True if a radar chart has category axis labels. Applies only to radar charts.
Type: boolean
Series.HasLeaderLines property
True if the series has leader lines.
Type: boolean
Series.LeaderLines property
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.
Type: Line
Series.LegendEntry property
Gets the legend entry according to this series.
Type: LegendEntry
Series.ShapeProperties property
Gets the ShapePropertyCollection object that holds the visual shape properties of the Series.
Type: ShapePropertyCollection
Series.BubbleSizeRepresents property
Gets what the bubble size represents on a bubble chart. The value of the property is BubbleSizeRepresents integer constant. NOTE: This member is now obsolete. Instead, please use Aspose.Cells.Charts.Series.SizeRepresents property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
Type: int
move(count)
Moves the series up or down.
| Parameter | Type | Description |
|---|---|---|
| count | int | The number of moving up or down. Move the series up if this is less than zero; Move the series down if this is greater than zero. |