View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Resizing many charts

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