Jan Nademlejnsky;222474 Wrote:
Is there a possibility to Select graph, Copy it and Paste it to another
sheet without being linked (Data Source) to original table?

I am looking for equivalent to Paste Special Format/Value for graphs.

I want to update graph, copy it as result to another sheet
(ResultFile), go
back update graph and paste it into the ResultFile under the previous
graph
and so on.

Everything is working as I wanted except that all the graphs are
sourcing
data from the last update, so all the graphs are identical.

I do not want to use screen print, because its resolution and very
time
consuming task. I have 756 graphs to be produced somehow this way.
I appreciate any help.

Thanks
Jan

There is a possibility, but I don't know how to translate it to VBA.
Open the the sheet with the graph
Click on Edit while pressing the Shift key
In the menu that appears select "Copy Picture"
You now have a picture of your graph in the clipBoard which you can now
paste anywhere

HTH


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61451