Resizing many charts
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
|