SetSpreadsheetData Method

Office 2003

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.