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

[MS]

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

 

[Bernard Liengme]

What version are you using? Copy Picture is on Excel 2003. Hold Shift before
click the Edit menu item
best wishes

 

[MS]

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.

 

[Jon Peltier]

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

 

[MS]

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

 

[MS]

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.

 

[Jon Peltier]

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

 

[Jon Peltier]

I hadn't run across this behavior, but it sure is a major drawback.

- Jon