graphs and charts? 1

[q4s72534]

How do you copy a graph/chart and paste it without the links.

 

[xlbo]

paste to where - if it is outside excel then just choose Edit>Pastespecial>Picture

If it is in excel, you have to copy it out of excel via the method above and then copy it back in I'm afraid

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[q4s72534]

in another excel booklet. it doesn't give me the option -paste special.

 

[xlbo]

Please read what I posted before

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[q4s72534]

Thank you so much

 

[q4s72534]

One more question. Is it easy to write a vb script using this method.

1.copy graph from excel sheet.
2.Paste graph on Paint
3.Copy graph from Paint
4.PasteSpecial/Picuture back to excel.


thanks

 

[xlbo]

not particularly but have a search in the archives - I'm sure this has come up before

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244