Hi there,
Have any of you ever created an excel graphic from vfp? If so, please share.
This is what I am doing:
1) pull data from legacy system SDF file
2) create a vfp table from the SDF file
3) Run some SELECT statments to come up with some statistical counts
4) From the results of the SELECT statment I need to create PIE charts
5) The VFP report should include the SELECT statements results along with the PIE chart, that I am trying to create in Excel.

By automating excel I've been able to export the SELECT statment results into an excel spreadsheet, and highlight the data range I need to create the PIE chart from, then WHAT? That is my question. Or is there any other way to do it?

Any advice is greatly appreciated.
Have a wonderful Thursday.