paper-xlsxAPI referencechart.surface_chart

SurfaceChart

paper-xlsx 0.2.1 API reference

SurfaceChart(**kw)

Attributes

`anchor`

attributeanchor

= 'E15'

`axId`

attributeaxId

= axId

`backWall`

attributebackWall

= backWall

`bandFmts`

attributebandFmts

= _SurfaceChartBase.bandFmts

`display_blanks`

attributedisplay_blanks

= 'gap'

`extLst`

attributeextLst

= Typed(expected_type=ExtensionList, allow_none=True)

`floor`

attributefloor

= floor

`graphical_properties`

attributegraphical_properties

= None

`height`

attributeheight

= 7.5

`idx_base`

attributeidx_base

= 0

`layout`

attributelayout

= None

`legend`

attributelegend

= Legend()

`mime_type`

attributemime_type

= 'application/vnd.openxmlformats-officedocument.drawingml.chart+xml'

`namespace`

attributenamespace

= None

`path`

attributepath

`pivotFormats`

attributepivotFormats

= ()

`pivotSource`

attributepivotSource

= None

`plot_area`

attributeplot_area

= PlotArea()

`roundedCorners`

attributeroundedCorners

= None

`ser`

attributeser

= _SurfaceChartBase.ser

`series`

attributeseries

= Alias('ser')

`sideWall`

attributesideWall

= sideWall

`style`

attributestyle

= None

`tagname`

attributetagname

= 'surfaceChart'

`title`

attributetitle

= None

`view3D`

attributeview3D

= view3D

`visible_cells_only`

attributevisible_cells_only

= True

`width`

attributewidth

= 15

`wireframe`

attributewireframe

= _SurfaceChartBase.wireframe

`x_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.

paramdata

paramfrom_rows

= False

paramtitles_from_data

= False

`append`

funcappend(value)

Append a data series to the chart

paramvalue

`from_tree`

funcfrom_tree(node)

Create object from XML

paramnode

`repoint`

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_index

paramnew_range

`set_categories`

funcset_categories(labels)

Set the categories / x-axis values

paramlabels

`to_tree`

functo_tree(namespace=None, tagname=None, idx=None)

paramnamespace

= None

paramtagname

= None

paramidx

= None

ChartBase

paper-xlsx 0.2.1 API reference

SurfaceChart3D

paper-xlsx 0.2.1 API reference