# openpyxl.chart.axis module

class openpyxl.chart.axis.ChartLines(spPr=None)

  Bases: `Serialisable`

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

  spPr

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

  tagname = 'chartLines'

class openpyxl.chart.axis.DateAxis(auto=None, lblOffset=None, baseTimeUnit=None, majorUnit=None, majorTimeUnit=None, minorUnit=None, minorTimeUnit=None, extLst=None, **kw)

  Bases: `TextAxis`

  auto

    Values must be of type <class ‘bool’>

  axId

    Values must be of type <class ‘int’>

  axPos

    Value must be one of [‘b’, ‘l’, ‘r’, ‘t’]

  baseTimeUnit

    Value must be one of [‘days’, ‘months’, ‘years’]

  crossAx

    Values must be of type <class ‘int’>

  crosses

    Value must be one of [‘autoZero’, ‘max’, ‘min’]

  crossesAt

    Values must be of type <class ‘float’>

  delete

    Values must be of type <class ‘bool’>

  extLst

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

  lblOffset

    Values must be of type <class ‘int’>

  majorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

  majorTickMark

    Value must be one of [‘cross’, ‘in’, ‘out’]

  majorTimeUnit

    Value must be one of [‘days’, ‘months’, ‘years’]

  majorUnit

    Values must be of type <class ‘float’>

  minorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

  minorTickMark

    Value must be one of [‘cross’, ‘in’, ‘out’]

  minorTimeUnit

    Value must be one of [‘days’, ‘months’, ‘years’]

  minorUnit

    Values must be of type <class ‘float’>

  numFmt

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

  scaling

    Values must be of type <class ‘openpyxl.chart.axis.Scaling’>

  spPr

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

  tagname = 'dateAx'
  tickLblPos

    Value must be one of [‘high’, ‘low’, ‘nextTo’]

  title

    Values must be of type <class ‘openpyxl.chart.title.Title’>

  txPr

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

class openpyxl.chart.axis.DisplayUnitsLabel(layout=None, tx=None, spPr=None, txPr=None)

  Bases: `Serialisable`

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

  layout

    Values must be of type <class ‘openpyxl.chart.layout.Layout’>

  spPr

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

  tagname = 'dispUnitsLbl'
  text

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

  textPropertes

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

  tx

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

  txPr

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

class openpyxl.chart.axis.DisplayUnitsLabelList(custUnit=None, builtInUnit=None, dispUnitsLbl=None, extLst=None)

  Bases: `Serialisable`

  builtInUnit

    Value must be one of [‘billions’, ‘hundredMillions’, ‘hundredThousands’, ‘hundreds’, ‘millions’, ‘tenMillions’, ‘tenThousands’, ‘thousands’, ‘trillions’]

  custUnit

    Values must be of type <class ‘float’>

  dispUnitsLbl

    Values must be of type <class ‘openpyxl.chart.axis.DisplayUnitsLabel’>

  extLst

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

  tagname = 'dispUnits'

class openpyxl.chart.axis.NumericAxis(crossBetween=None, majorUnit=None, minorUnit=None, dispUnits=None, extLst=None, **kw)

  Bases: `_BaseAxis`

  axId

    Values must be of type <class ‘int’>

  axPos

    Value must be one of [‘b’, ‘l’, ‘r’, ‘t’]

  crossAx

    Values must be of type <class ‘int’>

  crossBetween

    Value must be one of [‘between’, ‘midCat’]

  crosses

    Value must be one of [‘autoZero’, ‘max’, ‘min’]

  crossesAt

    Values must be of type <class ‘float’>

  delete

    Values must be of type <class ‘bool’>

  dispUnits

    Values must be of type <class ‘openpyxl.chart.axis.DisplayUnitsLabelList’>

  extLst

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

  classmethod from_tree(node)

    Special case value axes with no gridlines

  majorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

  majorTickMark

    Value must be one of [‘cross’, ‘in’, ‘out’]

  majorUnit

    Values must be of type <class ‘float’>

  minorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

  minorTickMark

    Value must be one of [‘cross’, ‘in’, ‘out’]

  minorUnit

    Values must be of type <class ‘float’>

  numFmt

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

  scaling

    Values must be of type <class ‘openpyxl.chart.axis.Scaling’>

  spPr

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

  tagname = 'valAx'
  tickLblPos

    Value must be one of [‘high’, ‘low’, ‘nextTo’]

  title

    Values must be of type <class ‘openpyxl.chart.title.Title’>

  txPr

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

class openpyxl.chart.axis.Scaling(logBase=None, orientation='minMax', max=None, min=None, extLst=None)

  Bases: `Serialisable`

  extLst

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

  logBase

    Values must be of type <class ‘float’>

  max

    Values must be of type <class ‘float’>

  min

    Values must be of type <class ‘float’>

  orientation

    Value must be one of [‘maxMin’, ‘minMax’]

  tagname = 'scaling'

class openpyxl.chart.axis.SeriesAxis(tickLblSkip=None, tickMarkSkip=None, extLst=None, **kw)

  Bases: `_BaseAxis`

  axId

    Values must be of type <class ‘int’>

  axPos

    Value must be one of [‘b’, ‘l’, ‘r’, ‘t’]

  crossAx

    Values must be of type <class ‘int’>

  crosses

    Value must be one of [‘autoZero’, ‘max’, ‘min’]

  crossesAt

    Values must be of type <class ‘float’>

  delete

    Values must be of type <class ‘bool’>

  extLst

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

  majorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

  majorTickMark

    Value must be one of [‘cross’, ‘in’, ‘out’]

  minorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

  minorTickMark

    Value must be one of [‘cross’, ‘in’, ‘out’]

  numFmt

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

  scaling

    Values must be of type <class ‘openpyxl.chart.axis.Scaling’>

  spPr

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

  tagname = 'serAx'
  tickLblPos

    Value must be one of [‘high’, ‘low’, ‘nextTo’]

  tickLblSkip

    Values must be of type <class ‘int’>

  tickMarkSkip

    Values must be of type <class ‘int’>

  title

    Values must be of type <class ‘openpyxl.chart.title.Title’>

  txPr

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

class openpyxl.chart.axis.TextAxis(auto=None, lblAlgn=None, lblOffset=100, tickLblSkip=None, tickMarkSkip=None, noMultiLvlLbl=None, extLst=None, **kw)

  Bases: `_BaseAxis`

  auto

    Values must be of type <class ‘bool’>

  axId

    Values must be of type <class ‘int’>

  axPos

    Value must be one of [‘b’, ‘l’, ‘r’, ‘t’]

  crossAx

    Values must be of type <class ‘int’>

  crosses

    Value must be one of [‘autoZero’, ‘max’, ‘min’]

  crossesAt

    Values must be of type <class ‘float’>

  delete

    Values must be of type <class ‘bool’>

  extLst

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

  lblAlgn

    Value must be one of [‘ctr’, ‘l’, ‘r’]

  lblOffset

    Values must be of type <class ‘float’>

  majorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

  majorTickMark

    Value must be one of [‘cross’, ‘in’, ‘out’]

  minorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

  minorTickMark

    Value must be one of [‘cross’, ‘in’, ‘out’]

  noMultiLvlLbl

    Values must be of type <class ‘bool’>

  numFmt

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

  scaling

    Values must be of type <class ‘openpyxl.chart.axis.Scaling’>

  spPr

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

  tagname = 'catAx'
  tickLblPos

    Value must be one of [‘high’, ‘low’, ‘nextTo’]

  tickLblSkip

    Values must be of type <class ‘int’>

  tickMarkSkip

    Values must be of type <class ‘int’>

  title

    Values must be of type <class ‘openpyxl.chart.title.Title’>

  txPr

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