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

torbjoen · Apr 22nd, 2002, 08:26 AM

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 ]

Mark W. · Apr 22nd, 2002, 08:50 AM

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 ]

Damon Ostrander · Apr 22nd, 2002, 09:03 AM

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.

torbjoen · Apr 22nd, 2002, 10:16 AM

Thanks, guys

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

Best regards,
Torbjørn

Apr 22nd, 2002, 09:03 AM	#3
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	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 (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 08:26 AM	#1
torbjoen New Member Join Date: Apr 2002 Posts: 5	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 ]

Apr 22nd, 2002, 08:50 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

Apr 22nd, 2002, 10:16 AM	#4
torbjoen New Member Join Date: Apr 2002 Posts: 5	Thanks, guys I'll go for the "Special Paste" suggestion! I can live with 2KB Best regards, Torbjørn