MSGraph Object

You can create a chart in a Microsoft Office document by using Automation from Visual Basic. The following code creates a new document in Microsoft Word, embeds and formats a chart, and then adds data to the chart.

http://support.microsoft.com/kb/244589