SetSpreadsheetData Method

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Binds the specified chart or chartspace to a range of cells on on a worksheet in the Spreadsheet Component. The chart must already be bound to a range of cells in the Spreadsheet Component before you call this method.

expression.SetSpreadsheetData(DataReference, SeriesByRows)

expression   Required. An expression that returns a ChartSpace or ChChart object.

DataReference  Required String. A reference to the range of cells to bind to. This can be in the form of a cell reference (A1:D5), or a defined name.

SeriesByRows  Optional Boolean. Specifies whether or not each row represents a data series. Set this property to False if each column represents a data series.

Example

This example binds ChartSpace1 to cells A1:F25 in the first sheet of Spreadsheet1.

  ChartSpace1.SetSpreadsheetData "Sheet1!A1:F25", False