Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

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

		


See Also | SetData Method


Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.