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

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.

It's probably easier to have a single series that has the min and max from
among all the data, and plot this as a hidden series on both axes.

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


"Del Cotter" wrote in message
...
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.