Chart.DataSource

Write only.Type: ValueTable; SpreadsheetDocumentRange.
Contains chart data source. Using this property, you can fill the chart with data contained in a spreadsheet document or value table.
Data in the source must be placed in the following manner:
When series are placed in chart columns (the property SeriesInRows equals False):

• If the source is a value table, its first column must contain the names of the chart points. The names of the chart series are taken from the column titles (the first column title is ignored).
• If the source is a spreadsheet document range, the names of the series are taken from the top row of the range. The names of the points are taken from the left column of the range. The contents of the top left cell are ignored.

When series are placed in chart rows (the property SeriesInRows equals True):

• If the source is a value table, its first column must contain the names of the chart series. The names of the chart points are taken from the column titles (the first column title is ignored).
• If the source is a spreadsheet document range, the names of the points are taken from the top row of the range. The names of the series are taken from the left column of the area. The contents of the top left cell are ignored.

Thin client, web-client, server, thick client, external connection, Mobile application (client), Mobile application (server).The chart is automatically refreshed when the data change.

---