DataSource Property

Returns or sets the ADO DataSource object that represents the data source for the specified control.


*expression   * Required. An expression that returns one of the objects in the Applies To list.


This example creates a chart that is bound to a spreadsheet. The series name is in cell B1, the category names are in cells A2:A28, and the values are in cells B2:B28.

Set c = ChartSpace1.Constants
Set ChartSpace1.DataSource = Spreadsheet1.Object
ChartSpace1.Charts(0).Type = c.chChartTypeLineMarkers
ChartSpace1.Charts(0).SetData c.chDimCategories, 0, "a2:a28"
ChartSpace1.Charts(0).SetData c.chDimSeriesNames, 0, "b1"
ChartSpace1.Charts(0).SeriesCollection(0).SetData c.chDimValues, 0, "b2:b28"

Applies to | ChartSpace Object | PivotTable Object | RecordNavigationControl Object | Spreadsheet Object

See Also | DataSourceName Property | SetData Method