ChartData class

Represents data used for a chart plotting.

The ChartData type exposes the following members:

Properties

Property	Description
`chart_data_workbook`	Gets the cells factory to create cells used for chart series or categories. Read-only `IChartDataWorkbook`.
`series`	Gets the series. Read-only `IChartSeriesCollection`.
`series_groups`	Gets the groups of series. Read-only `IChartSeriesGroupCollection`.
`categories`	Gets the primary categories (or both primary and secondary categories if `ChartData.use_secondary_categories` property is false). Read-only `IChartCategoryCollection`.
`use_secondary_categories`	If false then `ChartData.secondary_categories` property return null and data in `ChartData.categories` property is used both for primary and secondary series. If true then data in `ChartData.secondary_categories` property is used for secondary series and data in `ChartData.categories` property is used for primary series. Read/write bool.
`secondary_categories`	Gets the secondary categories if `ChartData.use_secondary_categories` property is true. Read-only `IChartCategoryCollection`.
`data_source_type`	Represents external workbook path if external data source, null otherwise
`external_workbook_path`	Represents data source of the chart

Method	Description
`set_external_workbook`	Sets external workbook as a data source for the chart. Chart data will be updated from the target workbook.
`set_external_workbook`	Sets external workbook as a data source for the chart.
`get_range`	Gets chart data range.
`set_range`	Set chart data range. Series and categories will be updated based on new data range. If amount of series in data range greater than count of series in the chart data then additional series with the same type as a last series in the current collection will be added to the end of the collection.
`switch_row_column`	Swap the data over the axis. Data being charted on the X axis will move to the Y axis and vice versa.