Article ID: 243192 - View products that this article applies to.
This article was previously published under Q243192
The Microsoft Office Chart Web Component can be used to create a chart using data from different sources, such as arrays, spreadsheets, and databases. This article describes how to use data in a Spreadsheet Web component to create a chart. When a chart is bound to spreadsheet data, changes made to the spreadsheet data are reflected in the chart.
To connect a chart to spreadsheet data, you can set the Datasource property of the Chartspace object to the Spreadsheet component that contains the data. The example below describes how to bind a spreadsheet control to a chart using VBScript:
View the page above in Microsoft Internet Explorer and note that the Chart and a Spreadsheet component appear on the page. Change the data in the Spreadsheet and note that the chart is updated accordingly.
For additional information about using the Chart Web Component, please click on the numbers below to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/240263/ )HOWTO: Create a Combination Chart with the Chart Web Component
(http://support.microsoft.com/kb/235885/ )HOWTO: Use the Office Chart Web Component With VB
Article ID: 243192 - Last Review: July 13, 2004 - Revision: 3.1
Contact us for more help
Connect with Answer Desk for expert help.