XySeriesData

The data specific to a particular XY 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.

The sequence of data points in an XY series is significant; lines are plotted following the sequence of points, even if that causes a line segment to "travel backward" (implying a multi-valued function). The data points are not automatically sorted into increasing order by X value.

Attributes

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

`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(x, y, number_format=None)

Return an XyDataPoint object newly created with values x and y, and appended to this sequence.

paramx

paramy

paramnumber_format

= None

`append`

funcappend(data_point)

paramdata_point

On this page