openpyxl.chart.plotarea module
- class openpyxl.chart.plotarea.DataTable(showHorzBorder=None, showVertBorder=None, showOutline=None, showKeys=None, spPr=None, txPr=None, extLst=None)[source]
Bases:
Serialisable
- extLst
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- graphicalProperties
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- showHorzBorder
Values must be of type <class ‘bool’>
- showKeys
Values must be of type <class ‘bool’>
- showOutline
Values must be of type <class ‘bool’>
- showVertBorder
Values must be of type <class ‘bool’>
- spPr
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- tagname = 'dTable'
- txPr
Values must be of type <class ‘openpyxl.chart.text.RichText’>
- class openpyxl.chart.plotarea.PlotArea(layout=None, dTable=None, spPr=None, _charts=(), _axes=(), extLst=None)[source]
Bases:
Serialisable
- area3DChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- areaChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- bar3DChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- barChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- bubbleChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- catAx
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- dTable
Values must be of type <class ‘openpyxl.chart.plotarea.DataTable’>
- dateAx
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- doughnutChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- extLst
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- graphicalProperties
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- layout
Values must be of type <class ‘openpyxl.chart.layout.Layout’>
- line3DChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- lineChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- ofPieChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- pie3DChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- pieChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- radarChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- scatterChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- serAx
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- spPr
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- stockChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- surface3DChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- surfaceChart
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
- tagname = 'plotArea'
- valAx
Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias