# openpyxl.chart.pivot module

class openpyxl.chart.pivot.PivotFormat(idx=0, spPr=None, txPr=None, marker=None, dLbl=None, extLst=None)

  Bases: `Serialisable`

  DataLabel

    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”)

  TextBody

    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”)

  dLbl

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

  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”)

  idx

    Values must be of type <class ‘int’>

  marker

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

  spPr

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

  tagname = 'pivotFmt'
  txPr

    Values must be of type <class ‘openpyxl.chart.text.RichText’>

class openpyxl.chart.pivot.PivotSource(name=None, fmtId=None, extLst=None)

  Bases: `Serialisable`

  extLst

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

  fmtId

    Values must be of type <class ‘int’>

  name

    Values must be of type <class ‘str’>

  tagname = 'pivotSource'