I have little experience with macros. However, if I had a chart on its own sheet and wanted to put it into, say, a Word Document, I would:
1. Select the chart so it had the squares in each corner
2. Hold down my Shift Key
3. Click Edit/Copy Picture
4. Click OK.
5. Go to Word Doc and Edit/Paste Special, Picture.
Hope this can help you.