I am not sure what you expect in response. You've described what you
want to do. So, why not do it? If you expect software to figure out
when the "types" of the two charts differ, you might be disappointed.

Of course, when the types are the same, you might simply want to use a
single axis. If the two are the same min. and max. value, there isn't
much point in having the 2nd axis, is there?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article , says...
Hi All,

I'm looking to plot data on primary and secondary axes, sometimes the data
is of different types, ie. sales $ and quantity.

When however, the data is of like type ie. sales $ and profit $, I'd like to
two axesto be synchronised so that they are effectively one axis, with a
minimum and maximum common for both primary and secondary axes.

When data reverts to being of different types, I'd like the axes to revert
back to independently auto.

Any ideas ?

VB is fine.

Thanks,

Neil