# openpyxl.chart.chartspace module

Enclosing chart object. The various chart types are actually child objects. Will probably need to call this indirectly

class openpyxl.chart.chartspace.ChartContainer(title=None, autoTitleDeleted=None, pivotFmts=(), view3D=None, floor=None, sideWall=None, backWall=None, plotArea=None, legend=None, plotVisOnly=True, dispBlanksAs='gap', showDLblsOverMax=None, extLst=None)

  Bases: `Serialisable`

  autoTitleDeleted

    Values must be of type <class ‘bool’>

  backWall

    Values must be of type <class ‘openpyxl.chart._3d.Surface’>

  dispBlanksAs

    Value must be one of [‘gap’, ‘span’, ‘zero’]

  extLst

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

  floor

    Values must be of type <class ‘openpyxl.chart._3d.Surface’>

  legend

    Values must be of type <class ‘openpyxl.chart.legend.Legend’>

  pivotFmts

    Wrap a sequence in an containing object

  plotArea

    Values must be of type <class ‘openpyxl.chart.plotarea.PlotArea’>

  plotVisOnly

    Values must be of type <class ‘bool’>

  showDLblsOverMax

    Values must be of type <class ‘bool’>

  sideWall

    Values must be of type <class ‘openpyxl.chart._3d.Surface’>

  tagname = 'chart'
  title

    Values must be of type <class ‘openpyxl.chart.title.Title’>

  view3D

    Values must be of type <class ‘openpyxl.chart._3d.View3D’>

class openpyxl.chart.chartspace.ChartSpace(date1904=None, lang=None, roundedCorners=None, style=None, clrMapOvr=None, pivotSource=None, protection=None, chart=None, spPr=None, txPr=None, externalData=None, printSettings=None, userShapes=None, extLst=None)

  Bases: `Serialisable`

  chart

    Values must be of type <class ‘openpyxl.chart.chartspace.ChartContainer’>

  clrMapOvr

    Values must be of type <class ‘openpyxl.drawing.colors.ColorMapping’>

  date1904

    Values must be of type <class ‘bool’>

  extLst

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

  externalData

    Values must be of type <class ‘openpyxl.chart.chartspace.ExternalData’>

  graphical_properties

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

  lang

    Values must be of type <class ‘str’>

  pivotSource

    Values must be of type <class ‘openpyxl.chart.pivot.PivotSource’>

  printSettings

    Values must be of type <class ‘openpyxl.chart.print_settings.PrintSettings’>

  protection

    Values must be of type <class ‘openpyxl.chart.chartspace.Protection’>

  roundedCorners

    Values must be of type <class ‘bool’>

  spPr

    Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>

  style

    Values must be of type <class ‘float’>

  tagname = 'chartSpace'
  textProperties

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

  to_tree(tagname=None, idx=None, namespace=None)
  txPr

    Values must be of type <class ‘openpyxl.chart.text.RichText’>

  userShapes

    Values must be of type <class ‘str’>

class openpyxl.chart.chartspace.ExternalData(autoUpdate=None, id=None)

  Bases: `Serialisable`

  autoUpdate

    Values must be of type <class ‘bool’>

  id

    Values must be of type <class ‘str’>

  tagname = 'externalData'

class openpyxl.chart.chartspace.Protection(chartObject=None, data=None, formatting=None, selection=None, userInterface=None)

  Bases: `Serialisable`

  chartObject

    Values must be of type <class ‘bool’>

  data

    Values must be of type <class ‘bool’>

  formatting

    Values must be of type <class ‘bool’>

  selection

    Values must be of type <class ‘bool’>

  tagname = 'protection'
  userInterface

    Values must be of type <class ‘bool’>