Chart aspect ratio streched when pasted into PP

[George wilson]

I am using office 2000 on a Windows 2000 system. I have an
XY scatter chart created in Excel. When I try to copy the
chart into another application, the chart is streched and
the aspect ratio of the pasted object is wrong. I have
tried pasting many different ways (paste special) and get
the same result. I tried pasting as an image into photo
editor and get the same result. I tried changing the
screen resolution, I know that messes up how some excel
charts view and that did not help either. Does anyone have
any suggestions how to force objects copied from Excel to
paste them as they look in excel?
TIA
George

 

[Guest]

I had a similar problem when I pasted into MS Word.
Fortunately in Word, the chart is pasted as an object and
I can go format-object, select the size tab, click off the
Lock Aspect Ratio checkbox, resize the height and width
dimension independent of each other until I get a good
picture, then check the Lock Aspect Ratio box back on.

 

[ChasGo]

Assuming you're pasting an "Object" into Word as opposed
to a "Picture," two things come to mind: (1) if you don't
mind a picture (not editable in Word), select your chart,
hold down SHIFT in Excel and in the Edit Menu look
for "Copy Picture," try the two choices that come up to
see if either solves your problem, and paste into Word.
(2) If you must have an object, once your object is pasted
into Word, right click on it, choose Open Object. Once
inside the Excel object, go to Tools | Options | Chart,
and uncheck "Size with Window." Then, under the File Menu
(still from within your Excel object), choose "Close and
Return to Word..."

HTH

 

[George Wilson]

Of course I have tried all the different paste special
options and I am aware that with tweaking you can adjust
the aspect ratio to be correct. The picture should paste
properly and then I should adjust the properties if I want
to do so afterwards. With having to copy/paste a hundred
charts into a document this operation gets old fast when
the product should work as intended out of the box. With
the price of licensing our corporation pays for MS office
suite I don't think it is too much to ask that it work as
intended. Is there a fix for this problem or do I just
have to live with it?
TIA
George

 

[George Wilson]

This workaround also distorts the lettering in the object.
The lettering ether scrunches together or runs off the
internal metadata text box which includes ungrouping to
fix.