How to copy worksheet layout, values and graph as picture

G

Guest

Dear Excel expert,

I'm trying to copy some worksheets to a new workbook. The sheets contain
formulas and graphs with references to other sheets. Therefor I would like to
have these references removed, thus copy them as values (but I also need the
same format/layout). The graphs should be copied as pictures to remove the
references.
I have succeeded in removing formula references by the copy - paste as
values methode, but I hope there is another methode. Converting a copied
graph into a picture within Excel doesn't work (only in Word I'm able to
paste it as a picture)

Regards,

jan Bart
 
G

Guest

Excelerate-nl:

copy graph month

e.g.

Sheets("Sheet1").ChartObjects("Chart 1").Select
ActiveChart.CopyPicture _
Appearance:=xlScreen, Size:=xlScreen, Format:=xlPicture
Sheets("Sheet2").Activate
Range("B10").Activate
ActiveSheet.Paste
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy paste formulas when running multiple instances of excel 2
How to prevent a graph update 2
Copy and Paste Graphs? 4
Excel 2007 'Copy as Picture' doesn't paste at 100% 1
Copy and paste a graph as a picture? 1
export value-copy to Mac excel 2
Copy Array to Array, how to and should I? 13
Formatting and copy or copy and formatting ?? 2

Top