This documentation is archived and is not being maintained.

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.


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

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


See Also | SetData Method