Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Placing graphs in MS Word: .doc-file grows LARGE!!

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi!

    I'm writing a report in MS Word, and I'm presenting some graphs inside the document.

    Right now I've put 3-4 graphs inside my word-doc, and when I'm finished, I will be looking at 10-30 graphs.

    I'm using "Insert->Object->Microsoft Word Picture" to paste in the graphs copied from Excel. I'm not interested in saving all the data within the word-doc, just the graph. And the resolution of the graph is much lower than the resolution of the data source.

    Before I put the 3-4 graphs into the doc, the size was 1.3MB, but afterwords it was 3,8MB! What will happen if I put 30 graphs inside it!? I'm guessing up to 40MB, or something!!!

    How can I prevent this? I thought of taking "print screens" of the graphs and presenting them as pictures, but that is a bad solution - very static.

    Thanks!

    Torbjørn

    [ This Message was edited by: torbjoen on 2002-04-22 07:26 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you considered saving your Excel document using "Save as HTML..." and then using Word's Insert | Picture | From File... menu command to add the GIFs created by Excel?

    [ This Message was edited by: Mark W. on 2002-04-22 07:51 ]

  3. #3
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi torbjoen,

    I think you will find that the most efficient way to paste graphs from Excel to Word is not via bitmap, but by Enhanced Metafile. Not only is this efficient, but maintains full quality and is scaleable. A simple graph will only add ~2KB to the file size. To paste the graph as an Enhanced Metafile simply copy the graph in Excel, then do an Edit -> Paste Special in Word, selecting the Enhanced Metafile option.
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, guys

    I'll go for the "Special Paste" suggestion! I can live with 2KB

    Best regards,
    Torbjørn

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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