Copying Graphs to Word

[Jim]

Using Office XL. I am copying graphs from Excel to a Word
document. The copy command does pick-up the graph area
and pastes over to Word. However, consistently it will
drop one or two legends/text boxes in the copying
process. Which one it drops is not consistent. The rest
of the graph will be great and pops right in. Any
suggestions? I can be corresponded to directly at this
newsgroup or e-mail.

 

[Bernard Liengme]

Have you tried Edit|Paste Special and specified Picture (Metafile)?
The chart will be static (not linked to Excel workbook).
Bernard

 

[Jon Peltier]

Jim -

Are these textboxes that you've manually added to the chart? If you
don't have the chart selected when you click on the textbox button, the
textbox will appear over the chart, but it won't be part of it. When you
copy the chart, the textbox won't be copied with it. One way to check:
when you select the chart, does the textbox disappear? Then it isn't
part of the chart.

- Jon

 

[Fernley Symons]

Have you tried first grouping all the text boxes with the drawing
tool? Also could try grouping the text boxes with the graph itself
prior to copying/pasting.

Sometimes I find a lack of Windows graphics resources means that
pictures don't transfer properly (this a problem with Win 2k/ Office
2k - haven't used your version). If this is the case the solution is
to shut the machine down for 10 secs and then reboot. You could also
up the virtual memory allocation (if this is possible) - I found
problems with incomplete copying/machine crashes until I did this.

Hope this helps


Fernley