CategorySeriesData

The data specific to a particular category chart series. It provides access to the series label, the series data points, and an optional number format to be applied to each data point not having a specified number format.

Attributes

`categories`

attributecategories

The data.Categories object that provides access to the category objects for this series.

`categories_ref`

attributecategories_ref

The Excel worksheet reference to the categories for this chart (not including the column heading).

`data_point_offset`

attributedata_point_offset

The integer count of data points that appear in all chart series prior to this one.

`index`

attributeindex

Zero-based integer indicating the sequence position of this series in its chart. For example, the second of three series would return 1.

`name`

attributename

The name of this series, e.g. 'Series 1'. This name is used as the column heading for the y-values of this series and may also appear in the chart legend and perhaps other chart locations.

`name_ref`

attributename_ref

The Excel worksheet reference to the cell containing the name for this series.

`number_format`

attributenumber_format

The formatting template string that determines how a number in this series is formatted, both in the chart and in the Excel spreadsheet; for example '#,##0.0'. If not specified for this series, it is inherited from the parent chart data object.

`values`

attributevalues

A sequence containing the (Y) value of each datapoint in this series, in data point order.

`values_ref`

attributevalues_ref

The Excel worksheet reference to the (Y) values for this series (not including the column heading).

`x_values`

attributex_values

A sequence containing the X value of each datapoint in this series, in data point order.

`x_values_ref`

attributex_values_ref

The Excel worksheet reference to the X values for this chart (not including the column heading).

`y_values`

attributey_values

A sequence containing the Y value of each datapoint in this series, in data point order.

`y_values_ref`

attributey_values_ref

The Excel worksheet reference to the Y values for this chart (not including the column heading).

Functions

`getitem`

func__getitem__(index)

paramindex

`len`

func__len__()

`add_data_point`

funcadd_data_point(value, number_format=None)

Return a CategoryDataPoint object newly created with value value, an optional number_format, and appended to this sequence.

paramvalue

paramnumber_format

= None

`append`

funcappend(data_point)

paramdata_point

On this page