This post might help. It shows how to calculate a proportional axis on a
dual-axis chart. The effect is to plot the movement of one series against
another to see how well they are correlated. Because each axis is calculated
as proportional to the other, both series are viewed in the same plane i.e.
no one series over or understates the visual effect of one against the other.

http://www.cellmatrix.net/index.php/...s_calculations

--
John Mansfield




"Patachoup" wrote:

hello!

To compare financial market assets moves I use a single chart with 2 series.

The chart has 2 vertical axes and the scales are pretty different in term of
values.

The autoscale works fine on both axes.

My queston is:

How do I translate a curve onto the other so that they get "stacked", to be
easily compared at a glance ?

Any VBA function or sub is welcome...

Thx