On Wed, 26 Mar 2008, in microsoft.public.excel.charting,
jk9533 said:

Anybody know how to auto adjust secondary axis scale to be the same as the
primary?

For each series on the primary axis, create a series on the secondary
axis which duplicates the data, and format it so it's invisible. And
vice versa for each series on the secondary axis.

Now whatever data prompts the primary axis to change will also make the
secondary axis change in exactly the same way.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.