openpyxl.chart.axis module¶
-
class
openpyxl.chart.axis.
ChartLines
(spPr=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.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:
openpyxl.chart.axis.TextAxis
-
auto
¶ Values must be of type <class ‘bool’>
-
axId
¶ Values must be of type <class ‘int’>
-
axPos
¶ Value must be one of {‘b’, ‘r’, ‘t’, ‘l’}
-
baseTimeUnit
¶ Value must be one of {‘months’, ‘years’, ‘days’}
-
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 {‘in’, ‘cross’, ‘out’}
-
majorTimeUnit
¶ Value must be one of {‘months’, ‘years’, ‘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 {‘in’, ‘cross’, ‘out’}
-
minorTimeUnit
¶ Value must be one of {‘months’, ‘years’, ‘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 {‘high’, ‘nextTo’, ‘low’}
-
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:
openpyxl.descriptors.serialisable.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:
openpyxl.descriptors.serialisable.Serialisable
-
builtInUnit
¶ Value must be one of {‘billions’, ‘tenThousands’, ‘tenMillions’, ‘millions’, ‘hundredMillions’, ‘trillions’, ‘thousands’, ‘hundredThousands’, ‘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:
openpyxl.chart.axis._BaseAxis
-
axId
¶ Values must be of type <class ‘int’>
-
axPos
¶ Value must be one of {‘b’, ‘r’, ‘t’, ‘l’}
-
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’>
-
majorGridlines
¶ Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
-
majorTickMark
¶ Value must be one of {‘in’, ‘cross’, ‘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 {‘in’, ‘cross’, ‘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’, ‘nextTo’, ‘low’}
-
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:
openpyxl.descriptors.serialisable.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:
openpyxl.chart.axis._BaseAxis
-
axId
¶ Values must be of type <class ‘int’>
-
axPos
¶ Value must be one of {‘b’, ‘r’, ‘t’, ‘l’}
-
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 {‘in’, ‘cross’, ‘out’}
-
minorGridlines
¶ Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
-
minorTickMark
¶ Value must be one of {‘in’, ‘cross’, ‘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’, ‘nextTo’, ‘low’}
-
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:
openpyxl.chart.axis._BaseAxis
-
auto
¶ Values must be of type <class ‘bool’>
-
axId
¶ Values must be of type <class ‘int’>
-
axPos
¶ Value must be one of {‘b’, ‘r’, ‘t’, ‘l’}
-
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’, ‘r’, ‘l’}
-
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 {‘in’, ‘cross’, ‘out’}
-
minorGridlines
¶ Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
-
minorTickMark
¶ Value must be one of {‘in’, ‘cross’, ‘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’, ‘nextTo’, ‘low’}
-
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’>
-