# openpyxl.chart.bar_chart module

class openpyxl.chart.bar_chart.BarChart(gapWidth=150, overlap=None, serLines=None, extLst=None, **kw)

  Bases: `_BarChartBase`

  barDir

    Value must be one of [‘bar’, ‘col’]

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

  grouping

    Value must be one of [‘clustered’, ‘percentStacked’, ‘stacked’, ‘standard’]

  overlap

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

  tagname = 'barChart'
  varyColors

    Values must be of type <class ‘bool’>

  x_axis

    Values must be of type <class ‘openpyxl.chart.axis.TextAxis’>

  y_axis

    Values must be of type <class ‘openpyxl.chart.axis.NumericAxis’>

class openpyxl.chart.bar_chart.BarChart3D(gapWidth=150, gapDepth=150, shape=None, serLines=None, extLst=None, **kw)

  Bases: `_BarChartBase`, `_3DBase`

  backWall

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

  barDir

    Value must be one of [‘bar’, ‘col’]

  dLbls

    Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>

  extLst

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

  floor

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

  gapDepth

    Values must be of type <class ‘float’>

  gapWidth

    Values must be of type <class ‘float’>

  grouping

    Value must be one of [‘clustered’, ‘percentStacked’, ‘stacked’, ‘standard’]

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

  shape

    Value must be one of [‘box’, ‘cone’, ‘coneToMax’, ‘cylinder’, ‘pyramid’, ‘pyramidToMax’]

  sideWall

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

  tagname = 'bar3DChart'
  varyColors

    Values must be of type <class ‘bool’>

  view3D

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

  x_axis

    Values must be of type <class ‘openpyxl.chart.axis.TextAxis’>

  y_axis

    Values must be of type <class ‘openpyxl.chart.axis.NumericAxis’>

  z_axis

    Values must be of type <class ‘openpyxl.chart.axis.SeriesAxis’>