PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Chart aspect ratio streched when pasted into PP
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Chart aspect ratio streched when pasted into PP
![]() |
Chart aspect ratio streched when pasted into PP |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
Guest
Posts: n/a
|
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 |
|
Guest
Posts: n/a
|
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 |
|
Guest
Posts: n/a
|
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 |
|
Guest
Posts: n/a
|
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 | |
| Rate This Thread | |
|
|

Main Page 

