Need workable sample of VFP/EXCEL automation
that programaticaly inserts/sets graph in Excel file.
Any help appreciated

Go to the Hentzenwerke web site and download the sample chapters for MegaFox: 1002 Things You Wanted to Know About Extending VFP One of the sample chapters is Chapter 6: Creating Charts and Graphs. There is detailed information on automating Excel to do this as well as some alternatives.