You really need VBA to do this. I wrote a little utility to do this, and
it's still immature, but you can give it a try:

http://peltiertech.com/Excel/Charts/...l#AlignChtDims

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

"spaceygrace" wrote in message
...
Using line graphs, how can I create plots that have the same plot areas
and
do not change size when the legends change or differ in size. I need to
make
12 identical plots that can be easily aligned and compared visually. They
need to differ only in the data plotted within those plot areas. My
problem
is that the plots change in size with the different legend sizes.