Hi Peter,
When you select and copy an area of Excel spreadsheet -- any area, not only chart -- data in graphics format usually appear in the Clipboard.
It may be a handle to either Enhanced Metafile or Bitmap file.
Quite a simple test can prove it:
- open Excel spreadsheet with a chart
- select chart cell and copy it to the Clipboard
- open Paint or any other graphics application
- paste data from the clipboard
Check FoxPro sample code, which enumerates data formats currently available on the clipboard:
http://www.news2news.com/vfp/?example=32* * *
Having a valid handle to graphics file (Enhanced Metafile or Bitmap) you are able to save graphics data attached to this handle in a file.
FoxPro example:
Storing clipboard content in a bitmap filehttp://www.news2news.com/vfp/?example=189* * *
Using Excel Automation you can find/select/copy all available charts on a spreadsheet.