Cropping an Excel chart

[HazelB]

I copied a chart from Excel into Word and now I need to crop out the white
space.
This is a client document for a quarterly publication and I don't have a
choice about changing it -- they expect it to appear as last quarter but with
this quarter's data.
But it appears that Word 2007 won't let me crop charts, which I was able to
do previously when using Word and Excel 2003.
Please help me!!!

 

[CyberTaz]

Prior to 2007 copying a chart & pasting into Word pasted as a picture which
you were able to crop. In 2007 the default is to paste as a MS Office
Graphic Object - which in this case *is* a Chart rather than a picture of
the chart, and chart objects can't be cropped. However...

If you copy the chart, then in Word use the option to Paste As Picture you
will be able to crop as you wish. In fact, you don't have to completely
start over - First cut the chart object you already have in the doc. Then
either:

A) Paste, then click the Paste Options button (which appears as a clipboard
icon at the lower right corner of the chart) & select Paste as Picture, or

B) Click the bottom part of the Paste button on the Home Tab, choose Paste
Special, then pick the preferred picture format to use.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Peter]

I found that if you insert an embedded object such as an Excel or Visio
object you can crop it by.

Selecting the object, right click and select the "format object" option.
Select the "Picture Tab"
Specify a negative value for the Crop From fields.

should not really be that hard though!!!!