Copy Chart as Picture

[Nokomis449]

I've seen several threads on here about the shift-edit Copy Picture technique. I want to paste a picture of a chart into another worksheet, re-size it, and have it dynamically updated when the original chart is updated. The shift-edit Copy Picture, along with the shift-edit Paste Picture process copies the chart picture to another worksheet just fine, but the picture does not automagically update when the original chart changes. I'm hoping to use this technique to create a dynamic Dashboard. What am I missing? Is there a better way? I'm VB illiterate and would prefer to stick with basics. I'm using Excel 2003.

Thanks in advance,
Jeff

 

[c_m]

I dont think you can do that without using VB. When you copy-paste as picture, excel breaks all the links that are required to update a chart picture.

I would simply record a macro and run that every time the chart is updated.

 

[pgc01]

Hi Jeff
Welcome to the board

It's not possible to copy the chart as a chart and paste link it. You can, however, copy the chart as a part of a picture of a worksheet range and paste link it. The chart will get copied with the range and will update automatically.

- Select a range from the cell below the top left corner of the chart to the cell below the bottom right corner of the chart
- Edit->Copy
- select a cell to paste the picture. It can be a cell in another worksheet.
- Shift Edit->Paste Picture Link

No problem if you resize the paste linked picture.

 

[Nokomis449]

Thanks for the responses.

PGC, I've been reading threads and other sites trying to find the answer, to no avail. Your solution works like a charm! Again, many thanks!

Jeff