# openpyxl.chart.plotarea module

class openpyxl.chart.plotarea.DataTable(showHorzBorder=None, showVertBorder=None, showOutline=None, showKeys=None, spPr=None, txPr=None, extLst=None)

  Bases: `Serialisable`

  extLst

    Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

  graphicalProperties

    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”)

  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)

  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’>

  classmethod from_tree(node)

    Create object from XML

  graphicalProperties

    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”)

  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'
  to_tree(tagname=None, idx=None, namespace=None)
  valAx

    Allow a multisequence to be built up from parts

    Excluded from the instance __elements__ or __attrs__ as is effectively an Alias