Which version of Excel are you working with?
In all my experience, anytime you copy an object the pasted object is
identical in all respects, including size. While writing this I have been
repeatedly doing so in '03. No matter what I size any chart as the pasted
duplicate is identical. Are you saying it happens differently for you?
Or are you creating charts 'as new sheets' and then copying them to a
worksheet? If so, the charts are not being resized - charts inserted as new
sheets are sized larger than the same chart would be if inserted 'as object
in' a worksheet. If that is the case, you might do better to insert the chart
directly into the worksheet where you want it displayed. Some resizing may
still be necessary. Height & width for each location option are set within
the program and I know of no available dialog for changing the default
dimensions. (Although it can be manipulated with VBA.)
Also, the Move/Size feature has no effect on Copy/Cut & Paste actions. It
only pertains to how/if an object is effected when Rows/Columns/Cells are
inserted or deleted.
Hope this is useful |:)
"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?
|