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

How to align charts on a page?
 

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" wrote in message
...
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