CODEWITHSUNDEEP
vbaexcel
dre
dre

Reputation: 183

Copy Chart from one workbook to another

Trying to copy multiple charts on one sheet, to another workbook as an image. It copies as a reference and not an image

wb.Sheets(w).ChartObjects("Chart 27").Chart.ChartArea.Copy
wb.Sheets(w).ChartObjects("Chart 19").Chart.ChartArea.Copy
ThisWorkbook.Sheets("Plots").Paste

I would like for the charts to be images, and not a direct copy with references. Also, for the charts to appear below one another, when I paste, it does it right on top of eachother

I want it to start at a certain cell, for example "A2"

Upvotes: 0

Views: 2275

Answers (1)

drec4s
drec4s

Reputation: 8077

For the charts to be pasted as images you must use this method:

ThisWorkbook.Sheets("Plots").Pictures.Paste

To have the charts placed below one another, you must first select the target cell where you want the chart to be placed.

Upvotes: 1

Related Questions