Hi!

Take a look to following link:
http://fox.wikis.com/wc.dll?Wiki~ExcelConstants~VFP

The constants match for Excel Chart and MS Graph control, as far as I know.


>Thanks Vlad
>Do you know by any chance where can i find a complete list of the graph types and subtypes constants?
>
>Jaime
>
>>Hi!
>>
>>No need to create the XLS file. If you want to use the graph directly in the VFP report, you can use the General field. find a samples here for MS Graph control with use of APPEND GENERAL command. This command puts a graph into the General field with default layout. Then you can automate it the usual way using the OLEBoundControl. Create the form and put the OLEBoundControl on it. Define General field with new MS Graph control as a ControlSource for OLEBoundControl. Then using simple reference to the OLEBoundControl object you can access all properties and methods of the MS Graph control, or Excel Chart control or whatever is inside of the General field. Help on all objects, properties and methods of the MS Graph control or otehr controls should exist separately. For MS Graph it is at the MS site, or you can find it on your disk for latest versions of MS Office when help file is installed.
>>
>>>I would like to give my users the option to print either data or graph, either to preview or to printer. Is it possible to implement this in a straightforward manner? I was thinking about creating an XLS file with the result cursor for my report in case of a graph output and then try to automate an Excel application object to preview or print the graph.
>>>
>>>Thanks
>>>Jaime