Cropping an Excel chart

Discussion in 'Word Graphics' started by HazelB, Dec 14, 2007.

  1. HazelB

    HazelB Guest

    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!!!
     
    HazelB, Dec 14, 2007
    #1
    1. Advertisements

  2. HazelB

    CyberTaz Guest

    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



    On 12/14/07 3:58 PM, in article
    , "HazelB"
    <> wrote:

    > 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, Dec 15, 2007
    #2
    1. Advertisements

  3. HazelB

    Peter Guest

    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!!!!

    "CyberTaz" wrote:

    > 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
    >
    >
    >
    > On 12/14/07 3:58 PM, in article
    > , "HazelB"
    > <> wrote:
    >
    > > 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!!!

    >
    >
     
    Peter, May 25, 2010
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Jim

    Irregular shaped cropping

    Jim, May 17, 2004, in forum: Word Graphics
    Replies:
    1
    Views:
    179
    Suzanne S. Barnhill
    May 17, 2004
  2. Rob
    Replies:
    2
    Views:
    118
    Graham Mayor
    Oct 11, 2004
  3. Alexi
    Replies:
    0
    Views:
    148
    Alexi
    Dec 29, 2004
  4. mominschool
    Replies:
    1
    Views:
    145
    Keith Howell
    Apr 9, 2006
  5. Rebecca

    Word 2003 Cropping Conundrum

    Rebecca, May 31, 2006, in forum: Word Graphics
    Replies:
    1
    Views:
    104
    Jezebel
    May 31, 2006
  6. John Law

    CROPPING IMAGES STORED ON THE CLIPBOARD

    John Law, Jan 16, 2007, in forum: Word Graphics
    Replies:
    2
    Views:
    127
    challa prabhu
    Jan 18, 2007
  7. Nick B

    Cropping Picture

    Nick B, Aug 13, 2007, in forum: Word Graphics
    Replies:
    2
    Views:
    128
    Nick B
    Aug 13, 2007
  8. Pierre Becquart

    Cropping unwanted black borders in JPEG images

    Pierre Becquart, Sep 27, 2007, in forum: Word Graphics
    Replies:
    1
    Views:
    115
    Pierre Becquart
    Oct 3, 2007
Loading...