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