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
     
    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!!!!
     
    Peter, May 25, 2010
    #3
    1. Advertisements

Ask a Question

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.