How to align charts on a page?

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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Larryq22" <Larryq22@discussions.microsoft.com> wrote in message
news:1EE5AF7B-4648-400B-9C22-435C9FE22D14@microsoft.com...
>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