View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Hosley Hosley is offline
external usenet poster
 
Posts: 14
Default Resizing many charts

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