ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Align Graphs (https://www.excelbanter.com/charts-charting-excel/66425-align-graphs.html)

jemma

Align Graphs
 

Hi,
I have produced lots of graphs and i need to multiple graphs per page.
Is there a way of easily aligning them so they all have the same space
between them etc.
So far i have been doing it by eye and it is a real headache
thanks, J


--
jemma
------------------------------------------------------------------------
jemma's Profile: http://www.excelforum.com/member.php...o&userid=30675
View this thread: http://www.excelforum.com/showthread...hreadid=503322


Jon Peltier

Align Graphs
 
Jemma -

If you hold the ALT key while moving and resizing the charts, their edges
will stick to the cell boundaries in the worksheet. If you set up a
worksheet with uniform column and row sizes, you should find aligning charts
with the ALT key relatively easy.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"jemma" wrote in
message ...

Hi,
I have produced lots of graphs and i need to multiple graphs per page.
Is there a way of easily aligning them so they all have the same space
between them etc.
So far i have been doing it by eye and it is a real headache
thanks, J


--
jemma
------------------------------------------------------------------------
jemma's Profile:
http://www.excelforum.com/member.php...o&userid=30675
View this thread: http://www.excelforum.com/showthread...hreadid=503322




jemma

Align Graphs
 

thanks, works well


--
jemma
------------------------------------------------------------------------
jemma's Profile: http://www.excelforum.com/member.php...o&userid=30675
View this thread: http://www.excelforum.com/showthread...hreadid=503322



All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com