View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Holger -

There are other reasons to stick with 100% zoom, but I'll respect your
preferences.

Hold down the shift key when you select a chart, so it is highlighted by
small white handles instead of small black ones. Now copy and paste the
chart, and it will not change in size from the original regardless of
zoom setting.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


holg3r wrote:

When looking at a worksheet at any zoom factor other than 100%,
copy-pasting an embedded chart multiplies the original chart size by
this zoom factor. Since I prefer to work with zoom factor 75%, pasted
charts always get smaller than their original copy. Thus, the only way
I know to obtain pasted copies at the original size is by first
switching to zoom factor 100%. This is most likely a bug of Excel but
if any of you knows a way to correct this counterintuitive behavior,
please let me know. Thanx!
(I'm using Excel 2003.)