PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Chart aspect ratio streched when pasted into PP

Reply

Chart aspect ratio streched when pasted into PP

 
Thread Tools Rate Thread
Old 06-02-2004, 10:56 PM   #1
George wilson
Guest
 
Posts: n/a
Default Chart aspect ratio streched when pasted into PP


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
  Reply With Quote
Old 06-02-2004, 11:34 PM   #2
Guest
 
Posts: n/a
Default Chart aspect ratio streched when pasted into PP

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.


>-----Original Message-----
>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
>.
>

  Reply With Quote
Old 09-02-2004, 12:45 AM   #3
ChasGo
Guest
 
Posts: n/a
Default Chart aspect ratio streched when pasted into PP

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
>-----Original Message-----
>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
>.
>

  Reply With Quote
Old 09-02-2004, 04:35 PM   #4
George Wilson
Guest
 
Posts: n/a
Default Chart aspect ratio streched when pasted into PP

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

>-----Original Message-----
>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
>>-----Original Message-----
>>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
>>.
>>

>.
>

  Reply With Quote
Old 09-02-2004, 04:54 PM   #5
George Wilson
Guest
 
Posts: n/a
Default Chart aspect ratio streched when pasted into PP

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.

>-----Original Message-----
>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
>>-----Original Message-----
>>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
>>.
>>

>.
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off