View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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