openpyxl.chart.pie_chart module
- class openpyxl.chart.pie_chart.CustomSplit(secondPiePt=())[source]
Bases:
Serialisable
- secondPiePt
A sequence of primitive types that are stored as a single attribute. “val” is the default attribute
- tagname = 'custSplit'
- class openpyxl.chart.pie_chart.DoughnutChart(firstSliceAng=0, holeSize=10, extLst=None, **kw)[source]
Bases:
_PieChartBase
- dLbls
Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>
- extLst
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- firstSliceAng
Values must be of type <class ‘float’>
- holeSize
Values must be of type <class ‘float’>
- ser
A sequence (list or tuple) that may only contain objects of the declared type
- tagname = 'doughnutChart'
- varyColors
Values must be of type <class ‘bool’>
- class openpyxl.chart.pie_chart.PieChart(firstSliceAng=0, extLst=None, **kw)[source]
Bases:
_PieChartBase
- dLbls
Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>
- extLst
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- firstSliceAng
Values must be of type <class ‘float’>
- ser
A sequence (list or tuple) that may only contain objects of the declared type
- tagname = 'pieChart'
- varyColors
Values must be of type <class ‘bool’>
- class openpyxl.chart.pie_chart.PieChart3D(varyColors=True, ser=(), dLbls=None)[source]
Bases:
_PieChartBase
- dLbls
Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>
- extLst
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- ser
A sequence (list or tuple) that may only contain objects of the declared type
- tagname = 'pie3DChart'
- varyColors
Values must be of type <class ‘bool’>
- class openpyxl.chart.pie_chart.ProjectedPieChart(ofPieType='pie', gapWidth=None, splitType='auto', splitPos=None, custSplit=None, secondPieSize=75, serLines=None, extLst=None, **kw)[source]
Bases:
_PieChartBase
From the spec 21.2.2.126
This element contains the pie of pie or bar of pie series on this chart. Only the first series shall be displayed. The splitType element shall determine whether the splitPos and custSplit elements apply.
- custSplit
Values must be of type <class ‘openpyxl.chart.pie_chart.CustomSplit’>
- 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’>
- join_lines
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”)
- ofPieType
Value must be one of {‘bar’, ‘pie’}
- secondPieSize
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’>
- splitPos
Values must be of type <class ‘float’>
- splitType
Value must be one of {‘cust’, ‘auto’, ‘val’, ‘pos’, ‘percent’}
- tagname = 'ofPieChart'
- type
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”)
- varyColors
Values must be of type <class ‘bool’>