paper-xlsxAPI referencechart.bar_chart
BarChart3D
paper-xlsx 0.2.1 API reference
BarChart3D(gapWidth=150, gapDepth=150, shape=None, serLines=None, extLst=None, **kw)Attributes
anchor
attributeanchor= 'E15'axId
attributeaxId= axIdbackWall
attributebackWall= _3DBase.backWallbarDir
attributebarDir= _BarChartBase.barDirdLbls
attributedLbls= _BarChartBase.dLblsdataLabels
attributedataLabels= Alias('dLbls')display_blanks
attributedisplay_blanks= 'gap'extLst
attributeextLst= Typed(expected_type=ExtensionList, allow_none=True)floor
attributefloor= _3DBase.floorgapDepth
attributegapDepth= gapDepthgapWidth
attributegapWidth= gapWidthgraphical_properties
attributegraphical_properties= Nonegrouping
attributegrouping= _BarChartBase.groupingheight
attributeheight= 7.5idx_base
attributeidx_base= 0layout
attributelayout= Nonelegend
attributelegend= Legend()mime_type
attributemime_type= 'application/vnd.openxmlformats-officedocument.drawingml.chart+xml'namespace
attributenamespace= Nonepath
attributepathpivotFormats
attributepivotFormats= ()pivotSource
attributepivotSource= Noneplot_area
attributeplot_area= PlotArea()roundedCorners
attributeroundedCorners= Noneser
attributeser= _BarChartBase.serserLines
attributeserLines= serLinesseries
attributeseries= Alias('ser')shape
attributeshape= shapesideWall
attributesideWall= _3DBase.sideWallstyle
attributestyle= Nonetagname
attributetagname= 'bar3DChart'title
attributetitle= Nonetype
attributetype= Alias('barDir')varyColors
attributevaryColors= _BarChartBase.varyColorsview3D
attributeview3D= _3DBase.view3Dvisible_cells_only
attributevisible_cells_only= Truewidth
attributewidth= 15x_axis
attributex_axis= TextAxis()y_axis
attributey_axis= NumericAxis()z_axis
attributez_axis= SeriesAxis()Functions
__iter__
func__iter__()add_data
funcadd_data(data, from_rows=False, titles_from_data=False)Add a range of data in a single pass. The default is to treat each column as a data series.
paramdataparamfrom_rows= Falseparamtitles_from_data= Falseappend
funcappend(value)Append a data series to the chart
paramvaluefrom_tree
funcfrom_tree(node)Create object from XML
paramnoderepoint
funcrepoint(series_index, new_range)Point a series' VALUES at new_range — "the chart now covers
Q1-Q4" (paper-xlsx). new_range must be a
sheet-qualified single-area range like "'Data'!$B$2:$B$13"; it is
validated here, and under preserve mode the save expresses the
change as a byte patch of the chart's <c:f> text.
paramseries_indexparamnew_rangeset_categories
funcset_categories(labels)Set the categories / x-axis values
paramlabelsto_tree
functo_tree(namespace=None, tagname=None, idx=None)paramnamespace= Noneparamtagname= Noneparamidx= None