A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Chart aspect ratio streched when pasted into PP



 
 
Thread Tools Display Modes
  #1  
Old February 6th, 2004, 10:56 PM
George wilson
external usenet poster
 
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
  #2  
Old February 6th, 2004, 11:34 PM
external usenet poster
 
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
.

  #3  
Old February 9th, 2004, 12:45 AM
ChasGo
external usenet poster
 
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
.

  #4  
Old February 9th, 2004, 04:35 PM
George Wilson
external usenet poster
 
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
.

.

  #5  
Old February 9th, 2004, 04:54 PM
George Wilson
external usenet poster
 
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
.

.

 




Thread Tools
Display Modes

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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.