paper-xlsxAPI referencechart.scatter_chart
ScatterChart
paper-xlsx 0.2.1 API reference
ScatterChart(scatterStyle=None, varyColors=None, ser=(), dLbls=None, extLst=None, **kw)Attributes
anchor
attributeanchor= 'E15'axId
attributeaxId= axIddLbls
attributedLbls= dLblsdataLabels
attributedataLabels= Alias('dLbls')display_blanks
attributedisplay_blanks= 'gap'extLst
attributeextLst= Typed(expected_type=ExtensionList, allow_none=True)graphical_properties
attributegraphical_properties= Noneheight
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= NonescatterStyle
attributescatterStyle= scatterStyleser
attributeser= serseries
attributeseries= Alias('ser')style
attributestyle= Nonetagname
attributetagname= 'scatterChart'title
attributetitle= NonevaryColors
attributevaryColors= varyColorsvisible_cells_only
attributevisible_cells_only= Truewidth
attributewidth= 15x_axis
attributex_axis= NumericAxis(axId=10, crossAx=20)y_axis
attributey_axis= NumericAxis(axId=20, crossAx=10)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