paper-xlsxAPI referencechart.stock_chart
StockChart
paper-xlsx 0.2.1 API reference
StockChart(ser=(), dLbls=None, dropLines=None, hiLowLines=None, upDownBars=None, extLst=None, **kw)Attributes
anchor
attributeanchor= 'E15'axId
attributeaxId= axIddLbls
attributedLbls= dLblsdataLabels
attributedataLabels= Alias('dLbls')display_blanks
attributedisplay_blanks= 'gap'dropLines
attributedropLines= dropLinesextLst
attributeextLst= Typed(expected_type=ExtensionList, allow_none=True)graphical_properties
attributegraphical_properties= Noneheight
attributeheight= 7.5hiLowLines
attributehiLowLines= hiLowLinesidx_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= serseries
attributeseries= Alias('ser')style
attributestyle= Nonetagname
attributetagname= 'stockChart'title
attributetitle= NoneupDownBars
attributeupDownBars= upDownBarsvisible_cells_only
attributevisible_cells_only= Truewidth
attributewidth= 15x_axis
attributex_axis= TextAxis()y_axis
attributey_axis= NumericAxis()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