Hi,
It may not be possible to set up a linking formula to achieve this.
So script code such as below could work, which simply gets the from and to y values of the two layers and sets the to value of the 2nd layer such that the zero position matches, it assumes of course zero is present in both ranges.
To use this, first set the From value of your 2nd layer Y axis to a suitable value, then copy these lines to script window, select them all and press Enter to execute.
// Make layer 1 active and get the from and to y values
page.active=1;
yy1=y1; yy2=y2;
// Make layer 2 active and get the from y value
page.active=2;
yy3=y1;
// Compute the new to y value
yy4=yy3+yy3*(yy2-yy1)/yy1;
// Set the new to y value
y2=yy4;
You can then keep changing the from value of 2nd layer and keep running this script again and again till you get a suitable range to cover all of the data in the 2nd layer.
Easwar
OriginLab
