Excel for creating charts

[CREvans]

Hi! I have some VBPro vbscript code that is creating an Excel spreadsheet with data just fine, but I have been unable to figure out how to use the data in the spreadsheet (or data in VBPro, since it's coming from the same source) to create a chart on that sheet of the data. Does anyone have any tips/tricks to doing this? All attempts I've tried have resulted in error messages about the Excel object not supporting the property or methods I've tried.

Thanks in advance!
Scott