# openpyxl.chart.series module

class openpyxl.chart.series.Series(idx=0, order=0, tx=None, spPr=None, pictureOptions=None, dPt=(), dLbls=None, trendline=None, errBars=None, cat=None, val=None, invertIfNegative=None, shape=None, xVal=None, yVal=None, bubbleSize=None, bubble3D=None, marker=None, smooth=None, explosion=None, extLst=None)

  Bases: `Serialisable`

  Generic series object. Should not be instantiated directly. User the chart.Series factory instead.

  bubble3D

    Values must be of type <class ‘bool’>

  bubbleSize

    Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>

  cat

    Values must be of type <class ‘openpyxl.chart.data_source.AxDataSource’>

  dLbls

    Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>

  dPt

    A sequence (list or tuple) that may only contain objects of the declared type

  data_points

    Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)

  errBars

    Values must be of type <class ‘openpyxl.chart.error_bar.ErrorBars’>

  explosion

    Values must be of type <class ‘int’>

  extLst

    Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

  graphicalProperties

    Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)

  identifiers

    Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)

  idx

    Values must be of type <class ‘int’>

  invertIfNegative

    Values must be of type <class ‘bool’>

  labels

    Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)

  marker

    Values must be of type <class ‘openpyxl.chart.marker.Marker’>

  order

    Values must be of type <class ‘int’>

  pictureOptions

    Values must be of type <class ‘openpyxl.chart.picture.PictureOptions’>

  shape

    Value must be one of [‘box’, ‘cone’, ‘coneToMax’, ‘cylinder’, ‘pyramid’, ‘pyramidToMax’]

  smooth

    Values must be of type <class ‘bool’>

  spPr

    Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>

  tagname = 'ser'
  title

    Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)

  to_tree(tagname=None, idx=None)

    The index can need rebasing

  trendline

    Values must be of type <class ‘openpyxl.chart.trendline.Trendline’>

  tx

    Values must be of type <class ‘openpyxl.chart.series.SeriesLabel’>

  val

    Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>

  xVal

    Values must be of type <class ‘openpyxl.chart.data_source.AxDataSource’>

  yVal

    Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>

  zVal

    Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)

class openpyxl.chart.series.SeriesLabel(strRef=None, v=None)

  Bases: `Serialisable`

  strRef

    Values must be of type <class ‘openpyxl.chart.data_source.StrRef’>

  tagname = 'tx'
  v

    Values must be of type <class ‘str’>

  value

    Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)

class openpyxl.chart.series.XYSeries(idx=0, order=0, tx=None, spPr=None, pictureOptions=None, dPt=(), dLbls=None, trendline=None, errBars=None, cat=None, val=None, invertIfNegative=None, shape=None, xVal=None, yVal=None, bubbleSize=None, bubble3D=None, marker=None, smooth=None, explosion=None, extLst=None)

  Bases: `Series`

  Dedicated series for charts that have x and y series

  bubble3D

    Values must be of type <class ‘bool’>

  bubbleSize

    Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>

  dLbls

    Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>

  dPt

    A sequence (list or tuple) that may only contain objects of the declared type

  errBars

    Values must be of type <class ‘openpyxl.chart.error_bar.ErrorBars’>

  idx

    Values must be of type <class ‘int’>

  invertIfNegative

    Values must be of type <class ‘bool’>

  marker

    Values must be of type <class ‘openpyxl.chart.marker.Marker’>

  order

    Values must be of type <class ‘int’>

  smooth

    Values must be of type <class ‘bool’>

  spPr

    Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>

  trendline

    Values must be of type <class ‘openpyxl.chart.trendline.Trendline’>

  tx

    Values must be of type <class ‘openpyxl.chart.series.SeriesLabel’>

  xVal

    Values must be of type <class ‘openpyxl.chart.data_source.AxDataSource’>

  yVal

    Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>