Pasting Excel chart into Word loses formatting

[Sandra]

How can I paste an .xls chart into Word and retain the formatting? I tried
copying and pasting (with Paste Special and regular Paste) and I am losing
the line spacing when the chart displays in Word.

Is there any way to gain control over this?

 

[Shane Devenshire]

Hi,

What do you mean by line spacing? what version of Excel are you using?

One why is to insert as Excel Chart or Worksheet Object.

Another general rule is to create a default size chart in Excel, don't
resize it. Then copy and paste it.

 

[Sandra]

Hi Shane,

Thanks for your response. It is actually my supervisor who showed me this
problem. I believe she is using Excel 2007 and Word 2007.

When she pastes the chart from Word into Excel, the information in the chart
becomes distorted. It is a fairly long chart with ~120 lines of data that
get squished together (i.e., the spacing between each line of data is
diminished to the point that it does not look good and is hard to read). We
tried using Paste Special and it came in the same way.

I am wondering if we need to import the chart rather than cutting and pasting?

Thank you.

Sandra

 

[Bernard Liengme]

Are you talking about a TABLE of data (numbers and text) or a CHART (ie a
graphic object) ?
best wishes

 

[artemis]

I had this, or a similar, problem a year or so ago and was given some
info on it by MS tech support. Try the following. I did find a problem
with the procedure however. It is that the length of the inserted page
was too long (a lot of white space at the bottom) and I couldn't find
a way to reduce it. It meant that that space could not be used for
text in the Word doc, and in some cases wrapped to the next page. Very
frustrating. There was some discussion on this board about this at the
time, including some from experts about why this now happens in 2007
versions.

First go into the chart page in Excel and set the print area around
the charts you want to copy. Then save the file with the charts page
showing as the active sheet.

1. Open Word document.

2. Select Insert tab, then Object (in the Text area), then Insert
Object, then Create from File.

3. Select file then OK.

4. When the page appears in Word it is not in the right format. Double
click inside it and wait while it goes through some sort of process.
(MS said wait till you are able to scroll again in the insert.) When
done click back in the document outside the insert.