Copy and Paste Graphs?

[Jan Nademlejnsky]

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

 

[Patrick Molloy]

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

 

[Peter T]

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]

Thank to everyone, but I would like to take Peter's offer, because I want to
copy
"real" charts with values, but no values linked to cells, please.

Thanks

Jan

 

[Peter T]

There are various techniques to "Delink" chart data from cells. The
simplest, apart from copying as a picture, is to include all the series data
in respective series formulas. Jon Peltier describes the approach here, also
with some basic VBA.

http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

The main limitation is the amount of data that can be stored in a series
formula. No "section" of the 4 to 5 part formula can be longer than 255,
including commas and curly brackets.

Another approach to handle virtually unlimited data is to store it all in
"Named arrays". This is not straightforward but effective.

I have an addin that uses both techniques and does quite a lot more, eg
process multiple charts in one go, delink other linked data (titles,
labels), re-link data to a new cell location (whether currently delinked or
simply to "move" the source cell data).

If interested drop me a line (address below).

Regards,
Peter T
pmbthornton gmail com