creat different charts to have same scale and size. For insertio.

[world-explorer-069]

Hi,

I am creating a page in my document that will display 4 different line
graphs. I need all 4 of them to have the same scale, and to be identical
(size of chart area vs. plot area, size of line spaces, etc) except for the
data. Is there a more exact way to do this, or do I just have to eyeball and
shrink/expand the size of each?

 

[Andy Pope]

Hi,

The only way to do this consistently is via the use of VBA code.
Have at look at Jon's addin.
http://peltiertech.com/Excel/Charts/chartvba.html#AlignChtDims

Also check the site for other examples of coding for charts.

Cheers
Andy