Aligning charts in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lesley - 25 Aug 2006 14:34 GMT

I have a series of charts on the same worksheet in excel. Is there a way to
align them without having to drag them manually (like the function in
PowerPoint)?

Reply to this Message

Andy Pope - 25 Aug 2006 15:01 GMT

Hi,

You can align the chartobjects easily enough using the Alignment options
on the Drawing toolbar. To select charts as objects rather than
activecharts hold the CTRL key when selecting the charts.

Is that the same method in powerpoint?

Align items within charts, such as plotarea, will require vba code.

Cheers
Andy

> I have a series of charts on the same worksheet in excel. Is there a way to
> align them without having to drag them manually (like the function in
> PowerPoint)?

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Lesley - 25 Aug 2006 16:28 GMT

Brilliant! Many thanks. I knew there should be something, just didn't know
how to select them all at once.

> Hi,
>
[quoted text clipped - 12 lines]
> > align them without having to drag them manually (like the function in
> > PowerPoint)?

Reply to this Message