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

 

[Pecoflyer]

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 shee
(ResultFile), go
back update graph and paste it into the ResultFile under the previou
graph
and so on.

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

I do not want to use screen print, because its resolution and ver
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 no
paste anywhere

HT

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste

 

[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