Hi Libby,

The DataObject only accepts text.

Record a macro, with the chart selected, on the main menu hold Shift and
select Edit, Copy Picture.
Experiment with the top two options but to copy as a metafile ensure the
Format option is Picture.

Tidy up the recorded macro.

Not sure what you mean by copy two charts then paste as a single metafile.
You will need to copy paste one at a time, maybe to can combine the two
images as one in the other application.

Regards,
Peter T