LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

Set the zoom to 100% before copying and pasting. If the zoom is 75%, a
copied chart will paste at 75% of the original size. (Not exactly 75%,
slightly larger). If the zoom is 50%, the pasted chart is close to 50%
of the original's size.

If you hold down Shift and click on a chart, you select the chart
object, which is the shape that contains the chart. It is selected when
the handles on the corners of the chart are white filled, not black.
Copying and pasting the chart object produces same-size charts at any zoom.

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

meyerse wrote:

When I copy and past a graph, excel resizes it. It does not matter if I say
move and size with cells or move and don't size with cells. I need to make
MANY graphs all of the same size. I created a custom layout, but I then must
manually resize every graph. Is there a way to copy and past as the same
size? Is there a way to LOCK this size as well?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Make graphs in Excel all the same size ready to paste into Word - sub210 Charts and Charting in Excel 4 April 25th 23 11:47 AM
line graphs in excel karl gauss Excel Worksheet Functions 1 March 17th 05 11:55 AM
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 12:02 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 06:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"