How to align charts on a page?

[Guest]

I have Office 2007. In Excel, I want to put 6 simple column-charts on a
page. All charts are the same size, and to fit text in between I need to
move the charts. How can I automatically align the charts on the page?
Excel Help sugggests "snap to grid" which I tried , but the settings are too
large and I can't find SmartArtTools to change them.

Thanks,
Larry

 

[Andy Pope]

Hi,

You could try the following.

Page Layout > Arrange > Selection Pane.
In the list of Shapes on this sheet select the charts, hold the CTRL key to
allow multiple selects.
Then Drawing Tools > Format > Arrange > Align > Align Left.

Cheers
Andy