openpyxl.chart.bar_chart module
- class openpyxl.chart.bar_chart.BarChart(gapWidth=150, overlap=None, serLines=None, extLst=None, **kw)[source]
Bases:
_BarChartBase
- barDir
Value must be one of {‘bar’, ‘col’}
- 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 {‘standard’, ‘stacked’, ‘percentStacked’, ‘clustered’}
- 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:
_BarChartBase
,_3DBase
- backWall
Values must be of type <class ‘openpyxl.chart._3d.Surface’>
- barDir
Value must be one of {‘bar’, ‘col’}
- 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 {‘standard’, ‘stacked’, ‘percentStacked’, ‘clustered’}
- 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 {‘pyramidToMax’, ‘pyramid’, ‘coneToMax’, ‘box’, ‘cylinder’, ‘cone’}
- 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’>