openpyxl.chart.axis module
- class openpyxl.chart.axis.ChartLines(spPr=None)[source]
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)[source]
Bases:
TextAxis- auto
Values must be of type <class ‘bool’>
- axId
Values must be of type <class ‘int’>
- axPos
Value must be one of {‘t’, ‘l’, ‘b’, ‘r’}
- baseTimeUnit
Value must be one of {‘years’, ‘months’, ‘days’}
- crossAx
Values must be of type <class ‘int’>
- crosses
Value must be one of {‘min’, ‘max’, ‘autoZero’}
- 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’, ‘out’, ‘in’}
- majorTimeUnit
Value must be one of {‘years’, ‘months’, ‘days’}
- 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’, ‘out’, ‘in’}
- minorTimeUnit
Value must be one of {‘years’, ‘months’, ‘days’}
- 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 {‘low’, ‘high’, ‘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)[source]
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)[source]
Bases:
Serialisable- builtInUnit
Value must be one of {‘hundredThousands’, ‘hundredMillions’, ‘tenThousands’, ‘trillions’, ‘billions’, ‘millions’, ‘tenMillions’, ‘thousands’, ‘hundreds’}
- 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)[source]
Bases:
_BaseAxis- axId
Values must be of type <class ‘int’>
- axPos
Value must be one of {‘t’, ‘l’, ‘b’, ‘r’}
- crossAx
Values must be of type <class ‘int’>
- crossBetween
Value must be one of {‘midCat’, ‘between’}
- crosses
Value must be one of {‘min’, ‘max’, ‘autoZero’}
- 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’>
- majorGridlines
Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
- majorTickMark
Value must be one of {‘cross’, ‘out’, ‘in’}
- 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’, ‘out’, ‘in’}
- 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 {‘low’, ‘high’, ‘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)[source]
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 {‘minMax’, ‘maxMin’}
- tagname = 'scaling'
- class openpyxl.chart.axis.SeriesAxis(tickLblSkip=None, tickMarkSkip=None, extLst=None, **kw)[source]
Bases:
_BaseAxis- axId
Values must be of type <class ‘int’>
- axPos
Value must be one of {‘t’, ‘l’, ‘b’, ‘r’}
- crossAx
Values must be of type <class ‘int’>
- crosses
Value must be one of {‘min’, ‘max’, ‘autoZero’}
- 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’, ‘out’, ‘in’}
- minorGridlines
Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
- minorTickMark
Value must be one of {‘cross’, ‘out’, ‘in’}
- 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 {‘low’, ‘high’, ‘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)[source]
Bases:
_BaseAxis- auto
Values must be of type <class ‘bool’>
- axId
Values must be of type <class ‘int’>
- axPos
Value must be one of {‘t’, ‘l’, ‘b’, ‘r’}
- crossAx
Values must be of type <class ‘int’>
- crosses
Value must be one of {‘min’, ‘max’, ‘autoZero’}
- 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 {‘l’, ‘ctr’, ‘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’, ‘out’, ‘in’}
- minorGridlines
Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
- minorTickMark
Value must be one of {‘cross’, ‘out’, ‘in’}
- 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 {‘low’, ‘high’, ‘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’>
