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

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

create a chart on sheet1. use this code as a demo ... it should copy the
chart onto a new workbook as a picture...



Option Explicit
Sub Demo()
Dim pic As Shape
With Sheet1
Set pic = .Shapes(1)
End With

Dim wb As Workbook
Set wb = Workbooks.Add
With wb.ActiveSheet
pic.Copy
.Range("B2").PasteSpecial
End With
End Sub

"Jan Nademlejnsky" 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

One of the copy chart as picture approaches is probably what you are after
(there are slightly different methods). But post back if you want to copy
"real" charts with values, but no values linked to cells.

Regards,
Peter T

"Jan Nademlejnsky" wrote in message
...
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