# openpyxl.chart.data_source module

Collection of utility primitives for charts.

class openpyxl.chart.data_source.AxDataSource(numRef=None, numLit=None, strRef=None, strLit=None, multiLvlStrRef=None)

  Bases: `Serialisable`

  multiLvlStrRef

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

  numLit

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

  numRef

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

  strLit

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

  strRef

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

  tagname = 'cat'

class openpyxl.chart.data_source.Level(pt=())

  Bases: `Serialisable`

  pt

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

  tagname = 'lvl'

class openpyxl.chart.data_source.MultiLevelStrData(ptCount=None, lvl=(), extLst=None)

  Bases: `Serialisable`

  extLst

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

  lvl

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

  ptCount

    Values must be of type <class ‘int’>

  tagname = 'multiLvlStrData'

class openpyxl.chart.data_source.MultiLevelStrRef(f=None, multiLvlStrCache=None, extLst=None)

  Bases: `Serialisable`

  extLst

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

  f

    Values must be of type <class ‘str’>

  multiLvlStrCache

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

  tagname = 'multiLvlStrRef'

class openpyxl.chart.data_source.NumData(formatCode=None, ptCount=None, pt=(), extLst=None)

  Bases: `Serialisable`

  extLst

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

  formatCode

    Values must be of type <class ‘str’>

  pt

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

  ptCount

    Values must be of type <class ‘int’>

class openpyxl.chart.data_source.NumDataSource(numRef=None, numLit=None)

  Bases: `Serialisable`

  numLit

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

  numRef

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

class openpyxl.chart.data_source.NumFmt(formatCode=None, sourceLinked=False)

  Bases: `Serialisable`

  formatCode

    Values must be of type <class ‘str’>

  sourceLinked

    Values must be of type <class ‘bool’>

class openpyxl.chart.data_source.NumRef(f=None, numCache=None, extLst=None)

  Bases: `Serialisable`

  extLst

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

  f

    Values must be of type <class ‘str’>

  numCache

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

  ref

    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.data_source.NumVal(idx=None, formatCode=None, v=None)

  Bases: `Serialisable`

  formatCode

    Values must be of type <class ‘str’>

  idx

    Values must be of type <class ‘int’>

  v

    Values must be of type <class ‘NoneType’>

class openpyxl.chart.data_source.NumberValueDescriptor(*args, **kw)

  Bases: `NestedText`

  Data should be numerical but isn’t always :-/

  allow_none = True

class openpyxl.chart.data_source.StrData(ptCount=None, pt=(), extLst=None)

  Bases: `Serialisable`

  extLst

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

  pt

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

  ptCount

    Values must be of type <class ‘int’>

  tagname = 'strData'

class openpyxl.chart.data_source.StrRef(f=None, strCache=None, extLst=None)

  Bases: `Serialisable`

  extLst

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

  f

    Values must be of type <class ‘str’>

  strCache

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

  tagname = 'strRef'

class openpyxl.chart.data_source.StrVal(idx=0, v=None)

  Bases: `Serialisable`

  idx

    Values must be of type <class ‘int’>

  tagname = 'strVal'
  v

    Values must be of type <class ‘str’>