## Series class

Encapsulates the object that represents a single data series in a chart.



The Series type exposes the following members:

### Properties
| Property | Description |
| :- | :- |
| [is_filtered](/cells/python-net/aspose.cells.charts/series/is_filtered) | Indicates whether the series is selected or filtered.True represents this series is filtered, and it will not be displayed on the chart. |
| [layout_properties](/cells/python-net/aspose.cells.charts/series/layout_properties) | Represents the properties of layout. |
| [points](/cells/python-net/aspose.cells.charts/series/points) | Gets the collection of points in a series in a chart. |
| [area](/cells/python-net/aspose.cells.charts/series/area) | Represents the background area of Series object. |
| [border](/cells/python-net/aspose.cells.charts/series/border) | Represents border of Series object. |
| [name](/cells/python-net/aspose.cells.charts/series/name) | Gets or sets the name of the data series. |
| [display_name](/cells/python-net/aspose.cells.charts/series/display_name) | Gets the series's name that displays on the chart graph. |
| [count_of_data_values](/cells/python-net/aspose.cells.charts/series/count_of_data_values) | Gets the number of the data values. |
| [is_vertical_values](/cells/python-net/aspose.cells.charts/series/is_vertical_values) | Indicates whether the data source is vertical. |
| [values](/cells/python-net/aspose.cells.charts/series/values) | Represents the Y values of this chart series. |
| [cached_values](/cells/python-net/aspose.cells.charts/series/cached_values) | Gets the cached values for the series |
| [cached_category_values](/cells/python-net/aspose.cells.charts/series/cached_category_values) | Gets the cached category values for the series |
| [point_values](/cells/python-net/aspose.cells.charts/series/point_values) | Represents the actual values that are used to plot every point in the chart.
<br/>corresponding to [`Series.values`](/cells/python-net/aspose.cells.charts/series#values)
<br/>When Series.Values is a link, you can use this attribute to get specific data.
<br/><br/>```python<br/>from aspose.cells import Workbook
<br/>
<br/>workbook = Workbook("YourFilePathName")
<br/>worksheet = workbook.worksheets[0]
<br/>chart = worksheet.charts[0]
<br/>chart.calculate()
<br/>#  Values could be like "[External.xlsx]Sheet1!$A$1:$A$6",
<br/>Values = chart.n_series[0].values
<br/>#  But when you can't get point values from "[External.xlsx]Sheet1!$A$1:$A$6",
<br/>#  For example, "External.xlsx" does not exist, then you can use PointValues,
<br/>#  It will return the values actually displayed in the Excel interface in the form of an array.
<br/>v1 = chart.n_series[0].point_values
<br/><br/>``` |
| [category_values](/cells/python-net/aspose.cells.charts/series/category_values) | Represents the actual category values that are used in the chart.
<br/>corresponding to [`Series.x_values`](/cells/python-net/aspose.cells.charts/series#x_values)
<br/>When Series.XValues is a link, you can use this attribute to get specific data.
<br/><br/>```python<br/>from aspose.cells import Workbook
<br/>
<br/>workbook = Workbook("YourFilePathName")
<br/>worksheet = workbook.worksheets[0]
<br/>chart = worksheet.charts[0]
<br/>chart.calculate()
<br/>#  XValues could be like "[External.xlsx]Sheet1!$B$2:$C$6",
<br/>XValues = chart.n_series[0].x_values
<br/>#  But when you can't get category values from "[External.xlsx]Sheet1!$B$2:$C$6",
<br/>#  For example, "External.xlsx" does not exist, then you can use CategoryValues,
<br/>#  It will return the category values actually displayed in the Excel interface in the form of a two-dimensional array.
<br/>v1 = chart.n_series[0].category_values
<br/><br/>``` |
| [values_format_code](/cells/python-net/aspose.cells.charts/series/values_format_code) | Represents format code of Values's NumberList. |
| [x_values_format_code](/cells/python-net/aspose.cells.charts/series/x_values_format_code) | Represents format code of X Values's NumberList. |
| [x_values](/cells/python-net/aspose.cells.charts/series/x_values) | Represents the X values of this chart series. |
| [bubble_sizes](/cells/python-net/aspose.cells.charts/series/bubble_sizes) | Gets or sets the bubble sizes values of the chart series. |
| [trend_lines](/cells/python-net/aspose.cells.charts/series/trend_lines) | Returns all the trendlines of this series. |
| [smooth](/cells/python-net/aspose.cells.charts/series/smooth) | Represents curve smoothing. 
<br/>True if curve smoothing is turned on for the line chart or scatter chart.
<br/>Applies only to line and scatter connected by lines charts. |
| [shadow](/cells/python-net/aspose.cells.charts/series/shadow) | True if the series has a shadow. |
| [has_3d_effect](/cells/python-net/aspose.cells.charts/series/has_3d_effect) | True if the series has a three-dimensional appearance. 
<br/>Applies only to bubble charts. |
| [bar_3d_shape_type](/cells/python-net/aspose.cells.charts/series/bar_3d_shape_type) | Gets or sets the 3D shape type used with the 3-D bar or column chart. |
| [data_labels](/cells/python-net/aspose.cells.charts/series/data_labels) | Represents the DataLabels object for the specified ASeries. |
| [type](/cells/python-net/aspose.cells.charts/series/type) | Gets or sets a data series' type. |
| [marker](/cells/python-net/aspose.cells.charts/series/marker) | Gets the [`Series.marker`](/cells/python-net/aspose.cells.charts/series#marker). |
| [plot_on_second_axis](/cells/python-net/aspose.cells.charts/series/plot_on_second_axis) | Indicates if this series is plotted on second value axis. |
| [x_error_bar](/cells/python-net/aspose.cells.charts/series/x_error_bar) | Represents X direction error bar of the series. |
| [y_error_bar](/cells/python-net/aspose.cells.charts/series/y_error_bar) | Represents Y direction error bar of the series. |
| [has_hi_lo_lines](/cells/python-net/aspose.cells.charts/series/has_hi_lo_lines) | True if the line chart has high-low lines. 
<br/>Applies only to line charts. |
| [hi_lo_lines](/cells/python-net/aspose.cells.charts/series/hi_lo_lines) | Returns a HiLoLines object that represents the high-low lines for a series on a line chart. 
<br/>Applies only to line charts. |
| [has_series_lines](/cells/python-net/aspose.cells.charts/series/has_series_lines) | True if a stacked column chart or bar chart has series lines or
<br/>if a Pie of Pie chart or Bar of Pie chart has connector lines between the two sections. 
<br/>Applies only to stacked column charts, bar charts, Pie of Pie charts, or Bar of Pie charts. |
| [series_lines](/cells/python-net/aspose.cells.charts/series/series_lines) | Returns a SeriesLines object that represents the series lines for a stacked bar chart or a stacked column chart.
<br/>Applies only to stacked bar and stacked column charts. |
| [has_drop_lines](/cells/python-net/aspose.cells.charts/series/has_drop_lines) | True if the chart has drop lines.
<br/>Applies only to line chart or area charts. |
| [drop_lines](/cells/python-net/aspose.cells.charts/series/drop_lines) | Returns a [`Line`](/cells/python-net/aspose.cells.drawing/line) object that represents the drop lines for a series on the line chart or area chart.
<br/>Applies only to line chart or area charts. |
| [has_up_down_bars](/cells/python-net/aspose.cells.charts/series/has_up_down_bars) | True if a line chart has up and down bars.
<br/>Applies only to line charts. |
| [up_bars](/cells/python-net/aspose.cells.charts/series/up_bars) | Returns an DropBars object that represents the up bars on a line chart.
<br/>Applies only to line charts. |
| [down_bars](/cells/python-net/aspose.cells.charts/series/down_bars) | Returns a [`DropBars`](/cells/python-net/aspose.cells.charts/dropbars) object that represents the down bars on a line chart.
<br/>Applies only to line charts. |
| [is_color_varied](/cells/python-net/aspose.cells.charts/series/is_color_varied) | Represents if the color of points is varied. 
<br/>The chart must contain only one series. |
| [gap_width](/cells/python-net/aspose.cells.charts/series/gap_width) | Returns or sets the space between bar or column clusters, as a percentage of the bar or column width.
<br/>The value of this property must be between 0 and 500. |
| [first_slice_angle](/cells/python-net/aspose.cells.charts/series/first_slice_angle) | Gets or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). 
<br/>Applies only to pie, 3-D pie, and doughnut charts, 0 to 360. |
| [overlap](/cells/python-net/aspose.cells.charts/series/overlap) | Specifies how bars and columns are positioned.
<br/>Can be a value between – 100 and 100. 
<br/>Applies only to 2-D bar and 2-D column charts. |
| [second_plot_size](/cells/python-net/aspose.cells.charts/series/second_plot_size) | Returns or sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, 
<br/>as a percentage of the size of the primary pie.
<br/>Can be a value from 5 to 200. |
| [split_type](/cells/python-net/aspose.cells.charts/series/split_type) | 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
<br/>pie chart. |
| [split_value](/cells/python-net/aspose.cells.charts/series/split_value) | Returns or sets a value that shall be used to determine which data points are in the second pie or bar on
<br/>a pie of pie or bar of pie chart. |
| [is_auto_split](/cells/python-net/aspose.cells.charts/series/is_auto_split) | Indicates whether the threshold value is automatic. |
| [bubble_scale](/cells/python-net/aspose.cells.charts/series/bubble_scale) | Gets or sets the scale factor for bubbles in the specified chart group. 
<br/>It can be an integer value from 0 (zero) to 300, 
<br/>corresponding to a percentage of the default size.
<br/>Applies only to bubble charts. |
| [size_represents](/cells/python-net/aspose.cells.charts/series/size_represents) | Gets or sets what the bubble size represents on a bubble chart. |
| [show_negative_bubbles](/cells/python-net/aspose.cells.charts/series/show_negative_bubbles) | True if negative bubbles are shown for the chart group. Valid only for bubble charts. |
| [doughnut_hole_size](/cells/python-net/aspose.cells.charts/series/doughnut_hole_size) | Returns or sets the size of the hole in a doughnut chart group. 
<br/>The hole size is expressed as a percentage of the chart size, between 10 and 90 percent. |
| [explosion](/cells/python-net/aspose.cells.charts/series/explosion) | The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter. |
| [has_radar_axis_labels](/cells/python-net/aspose.cells.charts/series/has_radar_axis_labels) | True if a radar chart has category axis labels. Applies only to radar charts. |
| [has_leader_lines](/cells/python-net/aspose.cells.charts/series/has_leader_lines) | True if the series has leader lines. |
| [leader_lines](/cells/python-net/aspose.cells.charts/series/leader_lines) | Represents leader lines on a chart. Leader lines connect data labels to data points. 
<br/>This object isn’t a collection; there’s no object that represents a single leader line. |
| [legend_entry](/cells/python-net/aspose.cells.charts/series/legend_entry) | Gets the legend entry according to this series. |
| [shape_properties](/cells/python-net/aspose.cells.charts/series/shape_properties) | Gets the [`ShapePropertyCollection`](/cells/python-net/aspose.cells.drawing/shapepropertycollection) object that holds the visual shape properties of the Series. |


### Methods
| Method | Description |
| :- | :- |
| [`move(self, count)`](/cells/python-net/aspose.cells.charts/series/move/#int) | Moves the series up or down. |



### Example 


```python
from aspose.cells import Workbook
from aspose.cells.charts import ChartMarkerType, ChartType, FormattingType
from aspose.pydrawing import Color

# Instantiating a Workbook object
workbook = Workbook()
# Adding a new worksheet to the Excel object
sheetIndex = workbook.worksheets.add()
# Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[sheetIndex]
# Adding a sample value to "A1" cell
worksheet.cells.get("A1").put_value(50)
# Adding a sample value to "A2" cell
worksheet.cells.get("A2").put_value(100)
# Adding a sample value to "A3" cell
worksheet.cells.get("A3").put_value(150)
# Adding a sample value to "A4" cell
worksheet.cells.get("A4").put_value(200)
# Adding a sample value to "B1" cell
worksheet.cells.get("B1").put_value(60)
# Adding a sample value to "B2" cell
worksheet.cells.get("B2").put_value(32)
# Adding a sample value to "B3" cell
worksheet.cells.get("B3").put_value(50)
# Adding a sample value to "B4" cell
worksheet.cells.get("B4").put_value(40)
# Adding a sample value to "C1" cell as category data
worksheet.cells.get("C1").put_value("Q1")
# Adding a sample value to "C2" cell as category data
worksheet.cells.get("C2").put_value("Q2")
# Adding a sample value to "C3" cell as category data
worksheet.cells.get("C3").put_value("Y1")
# Adding a sample value to "C4" cell as category data
worksheet.cells.get("C4").put_value("Y2")
# Adding a chart to the worksheet
chartIndex = worksheet.charts.add(ChartType.COLUMN, 5, 0, 15, 5)
# Accessing the instance of the newly added chart
chart = worksheet.charts[chartIndex]
# Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B4"
seriesIndex = chart.n_series.add("A1:B4", True)
# Setting the data source for the category data of NSeries
chart.n_series.category_data = "C1:C4"
series = chart.n_series[seriesIndex]
# 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.marker.marker_style = ChartMarkerType.CIRCLE
series.marker.foreground_color_set_type = FormattingType.AUTOMATIC
series.marker.foreground_color = Color.black
series.marker.background_color_set_type = FormattingType.AUTOMATIC
# do your business
# Saving the Excel file
workbook.save("book1.xls")

```

### See Also
* module [`aspose.cells.charts`](..)
* class [`DropBars`](/cells/python-net/aspose.cells.charts/dropbars)
* class [`Line`](/cells/python-net/aspose.cells.drawing/line)
* class [`ShapePropertyCollection`](/cells/python-net/aspose.cells.drawing/shapepropertycollection)