This indeed can be done! It will be frustrating, however, to manually tweak the scale and range of the 2nd axis so that the 2nd curve will exactly overlap the 1st one. You can instead create 2 sets of CUSTOMLABLES, and make the 2 sets match by pairs. Then apply 1 set to the 1st curve, and another set to the 2nd curve.
In my case, I need to show the same curve simultaneously as functions of angle Z and cos(Z), and cos(Z) is not even linear function of Z. So my 1st set of CUSTOMLABELS contain evenly spaced Z values, and 2nd set of CUSTOMLABELS contain cos(Z) values corresponding to the Z values in the 1st set. Then I applied Set 1 labels to X1, and Set 2 labels to X2. Job done.