Thread: Export charts into another workbook--without data

I'm working with numerous charts and workbooks, and I'd like to export my charts into a new workbook without the data sheets. I'm also using named ranges. Is there any way I can easily export the charts into a new workbook, without manually copying each chart and pasting as picture?

Any help would be appreciated!

Do you want your charts in the new workbook to change if the original data is changed? If not, then copying as a picture or screenshot is the logical method. If you do want it to be forever linked to the original workbook, then you should be able to directly copy and paste it into the new workbook and the links will stay in effect.

ChemistB