Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Aug 2005
    Location
    Columbus, Ohio, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pasting Charts from Excel to Word (Office 2003)

    Has anyone else had problems pasting charts from Excel into Word? Sometimes the charts are distorted after pasting, and often after choosing the "Paste Link" option and then editing the chart in Excel, the changes are NOT reflected in the Word documents. I has some distortion problems in Office XP before, but it seems to be even worse in Office 2003. Any observations or suggestions would be appreciated

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Putnam Valley, New York, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Charts from Excel to Word (Office 2003

    From my many years working for investment banks and pasting charts, here are some practices I adhere to:
    The chart should be on a separate chart sheet in Excel, not on the same sheet as the data

    The chart sheet should be sized (FILE, PAGE SETUP) so that the chart is approximately the final size it should be in Word. You can look HERE for some sizing hints.

    Linking in Word is fragile -- one has to make dead certain that the linked file hasn't been moved and the file with the links hasn't been moved either, and the link code is absolutely perfect. The code uses relative URLs, and I generally avoid linking unless there isn't an option. I actually prefer to paste the chart as a picture, and include a comment on where the Excel file lives. It does mean I have to repaste the picture when I make edits, but I find that a cleaner way to operate.

    I prefer to have either a style defined just for pictures, or a 1-cell table to keep the picture well-behaved

  3. #3
    New Lounger
    Join Date
    Aug 2005
    Location
    Columbus, Ohio, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Charts from Excel to Word (Office 2003

    Thank you, this was very helpful. The link to Stephanie Krieger's web site that you provided was also very useful. Creating tables as chartholders, moving charts to separate sheets, sizing them before pasting, and then pasting them as pictures without linking took a little while to set up and get used to, but it was worth it. My charts are not only a lot more stable, but the file size is also much smaller. Thanks again.

  4. #4
    Star Lounger
    Join Date
    Feb 2002
    Location
    Fort Collins, Colorado, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Charts from Excel to Word (Office 2003)

    I do A LOT of this, and I have found after much trial and error the following procedure that works good. It assumes, however, that you need only the APPEARANCE of a chart and not any FUNCTIONALITY--the result is a graphic image of the chart as a picture in your file.
    In Excel, select the cells that lie behind your chart
    Edit>paste (or ctrl-c) to copy to the clipboard
    In Word, Edit, Paste special, enhanced metafile
    That's it!
    I have found that this results in a picture image that is very true to the original chart, with no distortion. It is also freely scalable to fit your Word margins, page size, etc. (basically whatever size you need it to be) without any loss of quality. You can use this same technique to paste the chart into many other programs, e.g. PowerPoint.

    If you have a graphics program such as Visio, you can paste the chart into it using the same techniqe. Then select all and Save As an enhanced metafile, giving you a the chart in a file that is handy to save for future use. The same technique also works well for tables. In Visio, you can rotate the "table" image 90 degrees before saving it as an enhanced metafile, giving you a table in landscape orientation that can be pasted into Word. So far as I know, this is the only good way to place a long table broadside in Word.

  5. #5
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Charts from Excel to Word (Office 2003

    On my Win 2000 running Office 2000 system XL charts pasted as pictures into Word do not end up as the expected size based on their chartsheet page margins. Also, in the same room, on a Win XP running Office 2000 system and using the same XL chart as the final pasted picture is a different size <img src=/S/confused.gif border=0 alt=confused width=15 height=20> .

    The Format Picture dialog inculdes information on the 'original size' of the object, can anyone explain what it is that sets these dimensions?

    I'm stuck

  6. #6
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Putnam Valley, New York, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Charts from Excel to Word (Office 2003

    As a guess, I would say that printer drivers may be slightly different between the 2 systems. When pasting to Word, are you pasting inside a table or to an empty NORMAL paragraph, and are the pictures significantly larger or smaller than you expected? Is the page orientation of the Excel chart the same as the orientation of the Word document? Do the margins of the Excel chart include headers/footers?

  7. #7
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting Charts from Excel to Word (Office 2003

    Printer drivers may come into it but the two PCs are connected to the same networked printer. Similarly, I doubt this behaviour stems from page orientation or footers because I'm using the same XL workbook as the source and the same Word document as the destination, the difference is in the my PC is Win 2000 and the other PC is Win XP, suggesting the behaviour arises from differences in way the clipboards handle the copy and paste in these two cases.

    Using XL 97 on NT4 I can change the 'orignal size' as reported by Word 97 by adjusting the chartsheet margins but doing this in XL 2000 has no effect, Word 2000 always reports the same dimensions.

    I'm still experimenting with using a table or a text box as a holder. By the way upgrading to Office XP or 2003 is not an option.

    Meanwhile I'm still...
    stuck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •