Resizing many charts

[Hosley]

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]

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]

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

 

[Kelly O'Day]

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_vba.htm#Size_Align_Charts

I recommend freezing text size.

Kelly


Stop Spam - Edit E-mail address by removing **s
***[email protected]***

 

[Hosley]

The example looks perfect for what I need! Unfortunately I don't know
how to use Visual Basic, or basically how to get this button onto my
Excel sheets. Looks like there are lots of online tutorials, which I'll
look through, but in the meantime is there a quick way to use your VBA?

Thank you so much!

Kerry

 

[Andy Pope]

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