I think the Bode diagram from Electrical Engineering is a pretty good use of double y axes. It's a plot of circuit response showing both amplitude (in db) and phase (in deg) vs frequency.
You can certainly do it as a stack, but over-plotting the curves allows even easier comparisons of important frequencies for the response, and saves some space. Note that in this case, you would typically not have the axes share a 0.
