Hosley:

I have run into the same problem, so I made a VBA procedure to handle it.
Here' the link.

http://processtrends.com/pg_chart_vb...e_Align_Charts

I recommend freezing text size.

Kelly


Stop Spam - Edit E-mail address by removing **s
***


"Hosley" wrote in message
oups.com...
I'm not sure what the difference b/t objects ans active charts (I think
I know though), but when I hold select and click on a chartI get the
white circle outlines instead of the black squares. However, when I
then press CTRL+F1 all that happens is the Microsoft Help opens.

Thanks,

Kerry


Andy Pope wrote:
Hi,

If it's the actual chart object you want to resize you can do that by
selecting the chart whilst holding the SHIFT key. This will select the
charts as objects rather than a active chart.
Now you can press CTRL+F1 and change the size.

Cheers
Andy

Hosley wrote:
Hi there,

I need to resize a bunch of charts (all in one sheet) so that they have
equal sizes. Is there a way to automatically do this? The best way I
could think would be if I created a macro, where I could manually type
in the dimensions, but I don't even see a way to do that. Can I only
resize charts by click and dragging with the mouse? I would find that
hard to believe, and would make me wonder what everyone else in the
world does to avoid this issue. Any suggestions?


Thanks,

Hosley