Excell Chart Embedded in Word

G

Guest

I have embedded several excel charts in MS Word. This is done by copying the Excel chart and then using the "paste special" option and choosing to paste it as an embedded object (not a link). I have had to do this for various formatting reasons and pasting it as a picture or a link caused too much time going back to excel to re-format so it would look good in Word. Now in word when you double click on the chart you can edit it just like if it was still in excel

The problem (as I am sure you all will guess) is that the files in Word get very large. If the excel file from which a graph was inserted had 10 other graphs, all are inserted. And if there was 40,000 rows of data, they are all inserted too. I have gone to each of about 35 charts in the Word document and deleted all other charts and unnecessary worksheets but this reduced the file size by less than 1%. Does anyone know why this had such a small effect? If I remove 20 or 30 thousand rows of data (all data except for what is needed for that one particular chart) from every embedded chart, why is there not a more noticeable reduction in file size?
 
R

Robin Hammond

Brandt,

Embedding charts with the workbook should be a good solution, but has often
been fraught with problems. I just tried your technique and replicated the
problem despite trying to delete all extraneous data in the embedded sheet.
I was often following a similar process when sending charts into the
production department for reports, and found the best way was to create a
new workbook with only the data referred to by the charts in it. If you are
interested there is a routine in my XspandXL add-in that handles this,
allowing you to select multiple charts at a time, and export the charts with
only relevant associated data as values rather than formulas into a new
workbook, that is ideal for this kind of situation, keeping the size to an
absolute minimum while still giving you the editing functionality you want.
You can download a demo from my site. Run the Chart Browser and click on
Export, then select the Export As Charts option.

Robin Hammond
www.enhanceddatasystems.com


Brandt Saxey said:
I have embedded several excel charts in MS Word. This is done by copying
the Excel chart and then using the "paste special" option and choosing to
paste it as an embedded object (not a link). I have had to do this for
various formatting reasons and pasting it as a picture or a link caused too
much time going back to excel to re-format so it would look good in Word.
Now in word when you double click on the chart you can edit it just like if
it was still in excel.
The problem (as I am sure you all will guess) is that the files in Word
get very large. If the excel file from which a graph was inserted had 10
other graphs, all are inserted. And if there was 40,000 rows of data, they
are all inserted too. I have gone to each of about 35 charts in the Word
document and deleted all other charts and unnecessary worksheets but this
reduced the file size by less than 1%. Does anyone know why this had such a
small effect? If I remove 20 or 30 thousand rows of data (all data except
for what is needed for that one particular chart) from every embedded chart,
why is there not a more noticeable reduction in file size?
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top