ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   When copying and pasting charts the chart size decreases (https://www.excelbanter.com/charts-charting-excel/241929-when-copying-pasting-charts-chart-size-decreases.html)

Brad Angel

When copying and pasting charts the chart size decreases
 
Sometimes when in excel I can not copy charts and paste them without them
automatically decreasing in size by what looks to be a set ratio. i know to
select "don't move or size with cells", but this does not help. This problem
is erratic and can just start occurring in a worksheet after i have pasted
other charts without this problem. Any help with this would be much
appreciated.

Jon Peltier[_2_]

When copying and pasting charts the chart size decreases
 
In Excel 2003 and earlier, if the window zoom is not 100%, if you copy
an embedded chart and paste it, it will be pasted at a size
approximately equal to the original size times the zoom. This is one
reason it is often suggested that Excel only be used at 100%.

I have even written an article about this curiosity:

Copy and Paste Charts at Zooms other than 100%
http://peltiertech.com/WordPress/cop...t-other-zooms/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Brad Angel wrote:
Sometimes when in excel I can not copy charts and paste them without them
automatically decreasing in size by what looks to be a set ratio. i know to
select "don't move or size with cells", but this does not help. This problem
is erratic and can just start occurring in a worksheet after i have pasted
other charts without this problem. Any help with this would be much
appreciated.


Brad Angel[_2_]

When copying and pasting charts the chart size decreases
 
Thanks for your help with this Jon!! All good now.

"Jon Peltier" wrote:

In Excel 2003 and earlier, if the window zoom is not 100%, if you copy
an embedded chart and paste it, it will be pasted at a size
approximately equal to the original size times the zoom. This is one
reason it is often suggested that Excel only be used at 100%.

I have even written an article about this curiosity:

Copy and Paste Charts at Zooms other than 100%
http://peltiertech.com/WordPress/cop...t-other-zooms/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Brad Angel wrote:
Sometimes when in excel I can not copy charts and paste them without them
automatically decreasing in size by what looks to be a set ratio. i know to
select "don't move or size with cells", but this does not help. This problem
is erratic and can just start occurring in a worksheet after i have pasted
other charts without this problem. Any help with this would be much
appreciated.




All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com