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: Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

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 {‘pos’, ‘percent’, ‘val’, ‘auto’, ‘cust’}

tagname = 'ofPieChart'

type: Value must be one of {‘bar’, ‘pie’}

varyColors: Values must be of type <class ‘bool’>