How do I copy a graph so that I can paste it into Photoshop?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the old Excel versions Shift + edit gave the option "copy picture". This
does not seem to exist anymore and just copying a chart does not allow to
paste it into other programs like Photoshop.

Any help is greatly appreciated
 
What version are you using? Copy Picture is on Excel 2003. Hold Shift before
click the Edit menu item
best wishes
 
Bernard, Thanks for the reply. Yes I know that the older versions (including
2003 ) support the "copy picture" function through Shift Edit => Copy
picture..

However, I am using Office 2007 beta 2 in which this function appears to
have been deleted. There is the option to copy a chart to the clipboard but
the clipboard can only be exported to other Microsoft programs. Curiously,
that includes MS Paint but non-microsoft programs such as Adobe Photoshop
cannot see the clipboard and it is not possible to paste the copied chart
into a new file.

The two options are:
1 copy and paste into Paint and then reopen file in Photoshop
2 Print Screen and paste the entire screen into PS.

Either way is frankly unacceptable for publishing -- it just takes way too
long.

In other words, unless Microsoft adds the copy picture option back in (it
does not come up in the help menu / search either), the 2007 version is not
usable for mine and many other user's purposes.
 
Copy Picture is still present in Excel 2007, and it's right where you should
have thought to look: at the bottom of the Paste button dropdown (which
appears when you click the bottom half of the split button). I'm not sure
this is really more discoverable than Shift+Edit.

- Jon
 
Jon, Thanks but I have no idea what you are talking about. What is the "split
button"? is this something that needs to be custom-configured (it does not
show up in a "help search"

I would really appreciate if you could be a bit more precise in your
answers, that is, which one of the main menus contains the "paste button
dropdown" or else, where and how do I get to the Split menu you refer to.

Thanks in advance
 
Jon, Thanks, I found it. However, if I use the "copy as picture", even if the
graph is hi-lighted, it looks like it copies the picture and I can paste it
back into Excel and Paint - but not into Photoshop for example.

Arguably, I can save the picture as MS-paint file and then reopen that file
in PS but if you have to do 20-30 graphs for publication then this is just an
incredible nuisance. I still hope that somebody can point me to a way to do
the oldfashioned "Copy Picture" => "as bitmap" in a format that is recognized
by Photoshop, Corel or any other professional graphics program.
 
It's right next to all the Copy buttons, on the Clipboard group on the Home
tab of the Ribbon (no more menus), so I thought it would be easy to find.
You can discover how the split button works if you click around a bit.

- Jon
 
Back
Top