Help Excel chart to Word (97)

[Jack Crenshaw]

I'm not a new user, but I play one at the keyboard. I've been stuck at
Office 97 by choice, for many years. Now I need to copy a chart from
Excel into Word. I don't need the chart to be active -- a picture file
would be fine.

Wouldn't you think that Excel 97 and Word 97 would be compatible? I've
tried and tried, but to no avail.

In Word, I _CAN_ use Insert/Object to insert a new Excel Chart. I can
then copy all the worksheet data into the underlying array. Even then,
though, there seems to be no way to copy the existing chart to the new,
enbedded worksheet.

Anyone got the secret decoder ring?

Jack

 

[Suzanne S. Barnhill]

Try copying it in Excel and then use Paste Special | As Picture in Word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Jack Crenshaw]

Try copying it in Excel and then use Paste Special | As Picture in Word.

I did that. I can copy one figure that way. But when I tried to copy
two, it put the second one smack on top of the first. I think there
must be a setting in Word that's not right.

Thanks for the advice, though.

Jack

 

[Doug Robbins - Word MVP]

Select the first one that you pasted into Word and via the
Format>Picture>Layout tab, set the Wrapping style to In-line with text, then
select something the location in the document where you want the other one
to appear (so that the first image is not selected) and then paste in the
second one.

 

[Jack Crenshaw]

ALL RIGHT!!! That sounds like it should work, Doug. Thanks!!

Jack

 

[Jack Crenshaw]

Select the first one that you pasted into Word and via the
Format>Picture>Layout tab, set the Wrapping style to In-line with text,
then select something the location in the document where you want the
other one to appear (so that the first image is not selected) and then
paste in the second one.

Well, it wasn't quite the same, Doug, but close enough. In Word 97, the
selection box is "Float over text." But I got the same result. Many
thanks!!!

Jack

 

[Suzanne S. Barnhill]

In Word 97, the default is to inline. "Float over text" makes it wrapped. In
Word 2000 and above, the default is some kind of wrapping (often In Front of
Text, maybe Square), but at least in Word 2002 and above you can choose the
default you prefer.

But the point here is that, regardless of what kind of wrapping you're
using, if you have the previously inserted chart selected when you paste
another, you're going to replace the selected one. You have to deselect the
previously pasted one before pasting another. And, if you're pasting wrapped
("floating") rather than inline, there's still a chance that the new one
will be in front of (on top of) the previous one.

For more on all this, see http://word.mvps.org/FAQs/DrwGrphcs/DrawLayer.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org