The selection part is working. You do indeed get white circles instead
of black squares.
My bad CTRL+1
Another way to bring up the format dialog would be menu Format Objects.
Cheers
Andy
Hosley wrote:
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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info