Excel for creating charts
 

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

This thread and link might help:
http://www.kinook.com/Forum/showthread.php?threadid=500