openpyxl.chart.bar_chart module¶
-
class
openpyxl.chart.bar_chart.
BarChart
(gapWidth=150, overlap=None, serLines=None, extLst=None, **kw)[source]¶ Bases:
openpyxl.chart.bar_chart._BarChartBase
-
barDir
¶ Value must be one of {‘col’, ‘bar’}
-
dLbls
¶ Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>
-
extLst
¶ Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
-
gapWidth
¶ Values must be of type <class ‘float’>
-
grouping
¶ Value must be one of {‘stacked’, ‘clustered’, ‘percentStacked’, ‘standard’}
-
overlap
¶ Values must be of type <class ‘float’>
-
ser
¶ A sequence (list or tuple) that may only contain objects of the declared type
-
serLines
¶ Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
-
tagname
= 'barChart'¶
-
varyColors
¶ Values must be of type <class ‘bool’>
-
x_axis
¶ Values must be of type <class ‘openpyxl.chart.axis.TextAxis’>
-
y_axis
¶ Values must be of type <class ‘openpyxl.chart.axis.NumericAxis’>
-
-
class
openpyxl.chart.bar_chart.
BarChart3D
(gapWidth=150, gapDepth=150, shape=None, serLines=None, extLst=None, **kw)[source]¶ Bases:
openpyxl.chart.bar_chart._BarChartBase
,openpyxl.chart._3d._3DBase
-
backWall
¶ Values must be of type <class ‘openpyxl.chart._3d.Surface’>
-
barDir
¶ Value must be one of {‘col’, ‘bar’}
-
dLbls
¶ Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>
-
extLst
¶ Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
-
floor
¶ Values must be of type <class ‘openpyxl.chart._3d.Surface’>
-
gapDepth
¶ Values must be of type <class ‘float’>
-
gapWidth
¶ Values must be of type <class ‘float’>
-
grouping
¶ Value must be one of {‘stacked’, ‘clustered’, ‘percentStacked’, ‘standard’}
-
ser
¶ A sequence (list or tuple) that may only contain objects of the declared type
-
serLines
¶ Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
-
shape
¶ Value must be one of {‘cylinder’, ‘cone’, ‘pyramid’, ‘box’, ‘coneToMax’, ‘pyramidToMax’}
-
sideWall
¶ Values must be of type <class ‘openpyxl.chart._3d.Surface’>
-
tagname
= 'bar3DChart'¶
-
varyColors
¶ Values must be of type <class ‘bool’>
-
view3D
¶ Values must be of type <class ‘openpyxl.chart._3d.View3D’>
-
x_axis
¶ Values must be of type <class ‘openpyxl.chart.axis.TextAxis’>
-
y_axis
¶ Values must be of type <class ‘openpyxl.chart.axis.NumericAxis’>
-
z_axis
¶ Values must be of type <class ‘openpyxl.chart.axis.SeriesAxis’>
-