copy and paste chart only

[dennisli]

Good afternoon,
In Excel, I can copy and paste value only.
How about for charts? Since I just want to send chart out.
Another issue is my chart was created under 2003 version. When opened under 2007 version, the layout has been changed.
Any ideas?
Thank
Dennis

 

[sulakvea]

hi Dennis, not sure about the second Q - i use 2003.

First one - i am also not quite sure what you mean by Copy / Paste Values when it comes to charts, but i guess the closest match would be to copy as picture -i.e. all the formatting and references will be removed. if so, then you can use this line:

Sheet1.ChartObjects("Chart 1").Chart.CopyPicture

 

[VoG]

Perhaps http://peltiertech.com/WordPress/export-chart-as-image-file/

 

[dennisli]

thank you all. have a good day.