ExcelBanter - Copying a chart

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copying a chart (https://www.excelbanter.com/excel-programming/308226-copying-chart.html)

Linda Mac

Copying a chart

I want to copy a chart from one workbook to another. But,
I don't want the second workbook to have links to the
first. Is there a way to copy the chart as a picture or
object?

JE McGimpsey

Copying a chart

Hold down the shift key and choose Edit/Copy Picture...

In article ,
"Linda Mac" wrote:

I want to copy a chart from one workbook to another. But,
I don't want the second workbook to have links to the
first. Is there a way to copy the chart as a picture or
object?

JE McGimpsey

Copying a chart

Or, since this is the programming group:

ActiveChart.CopyPicture Appearance:=xlScreen, Size:=xlScreen

In article ,
"Linda Mac" wrote:

I want to copy a chart from one workbook to another. But,
I don't want the second workbook to have links to the
first. Is there a way to copy the chart as a picture or
object?

All times are GMT +1. The time now is 06:04 PM.