Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jennifer
 
Posts: n/a
Default Putting Excel Charts into a Word document that's getting too big

I am creating a Word document (our Annual Report) in which I will have many
charts and graphs that were created in Excel. Currently, there will be at
least 26 graphs/charts in the document.

In the past, there have apparently been problems with not having enough
space to save the Word document because it gets too big. The document itself
is only about 36 pages, but, as I mentioned, within the 36 pages are at least
26 graphs and charts. I'm looking for a way to copy the graphs/charts into
Excel without it taking so much memory.

One solution we thought of was to only paste the graph/chart once we know
the data will not change, and to paste it in without any links. However, I
can't figure out how to do this.

Because the graphs/charts are so complicated, and have so much data, they
seem to be too big.

Does anyone have any suggestions for what I could do about this? What's the
best way to copy the charts/graphs into Word?

We are using Excel and Word 2000 if that makes a difference.

Jennifer
  #2   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day
 
Posts: n/a
Default Putting Excel Charts into a Word document that's getting too big

There are several aspects to your question. One key point that I'd like to
make is the idea you can add dumb pictures of your Excel charts which
require very little space or you can add the entire workbook and Excel
chart.

It sounds like you are copying the Excel chart in Excel then going to word
and hitting paste. When you do this you are actually copying the entire
book.

The alternative method that reduces file size in word is to use Edit Paste
Special (Enhanced meta File . with this method you have a dumb picture, no
link back to Excel file. However, you have a smaller Word file, important
when you have dozens of charts.

You can reduce size even further by Exporting Excel charts as jpeg or gif
files then importing into Word.

Hope this helps.




"Jennifer" wrote in message
...
I am creating a Word document (our Annual Report) in which I will have many
charts and graphs that were created in Excel. Currently, there will be at
least 26 graphs/charts in the document.

In the past, there have apparently been problems with not having enough
space to save the Word document because it gets too big. The document
itself
is only about 36 pages, but, as I mentioned, within the 36 pages are at
least
26 graphs and charts. I'm looking for a way to copy the graphs/charts
into
Excel without it taking so much memory.

One solution we thought of was to only paste the graph/chart once we know
the data will not change, and to paste it in without any links. However,
I
can't figure out how to do this.

Because the graphs/charts are so complicated, and have so much data, they
seem to be too big.

Does anyone have any suggestions for what I could do about this? What's
the
best way to copy the charts/graphs into Word?

We are using Excel and Word 2000 if that makes a difference.

Jennifer



  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Putting Excel Charts into a Word document that's getting too big

If you decide to use bitmaps, don't use jpg, use png or gif. However,
bitmaps are not as good a choice, because you can't change their size, even
a little, without distortion. Metafiles are tolerant of resizing, at least
to an extent. FWIW, there is no difference in the appearance of a regular
and an enhanced metafile; the difference relates to header information
hidden away in the file. A metafile may even be smaller than a bitmapped
image.

I'd paste the pictures using paste special - links. This contributes hardly
any more to the Word file size than a metafile, but it's dynamic, in case
the data is still moving, and at the end of the process, you can copy the
linked chart in Word, then paste special again, as a metafile. Or even go to
Edit Links, and break the link, which converts the chart to a metafile.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"Kelly O'Day" wrote in message
...
There are several aspects to your question. One key point that I'd like to
make is the idea you can add dumb pictures of your Excel charts which
require very little space or you can add the entire workbook and Excel
chart.

It sounds like you are copying the Excel chart in Excel then going to word
and hitting paste. When you do this you are actually copying the entire
book.

The alternative method that reduces file size in word is to use Edit
Paste Special (Enhanced meta File . with this method you have a dumb
picture, no link back to Excel file. However, you have a smaller Word
file, important when you have dozens of charts.

You can reduce size even further by Exporting Excel charts as jpeg or gif
files then importing into Word.

Hope this helps.




"Jennifer" wrote in message
...
I am creating a Word document (our Annual Report) in which I will have
many
charts and graphs that were created in Excel. Currently, there will be
at
least 26 graphs/charts in the document.

In the past, there have apparently been problems with not having enough
space to save the Word document because it gets too big. The document
itself
is only about 36 pages, but, as I mentioned, within the 36 pages are at
least
26 graphs and charts. I'm looking for a way to copy the graphs/charts
into
Excel without it taking so much memory.

One solution we thought of was to only paste the graph/chart once we know
the data will not change, and to paste it in without any links. However,
I
can't figure out how to do this.

Because the graphs/charts are so complicated, and have so much data, they
seem to be too big.

Does anyone have any suggestions for what I could do about this? What's
the
best way to copy the charts/graphs into Word?

We are using Excel and Word 2000 if that makes a difference.

Jennifer





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert a word document into a Excel document gwiltz2 Excel Discussion (Misc queries) 1 October 22nd 05 07:04 PM
Problems printing a word document with linked excel tables. jcarlos Excel Discussion (Misc queries) 0 August 30th 05 04:01 PM
How to change a excel document into a word document? wannaknow Excel Discussion (Misc queries) 1 July 27th 05 09:37 PM
How do you replace a work sheet in excel with a word document? DonxCahill Excel Discussion (Misc queries) 2 July 11th 05 05:03 PM
Add a Word Document as a Tab in an Excel Document GoDamN Excel Discussion (Misc queries) 4 December 29th 04 11:41 PM


All times are GMT +1. The time now is 11:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"