Combination XY scatter plots

[Guest]

I have two sets of data with a common x-axis, but need to be scaled
differently, so using multiple series on a single plot is not convenient.

Is there a way to combine the two scatter plots so that each y-axis can be
independantly scaled?

 

[David Biddulph]

Select one of the series, Format selected series, axis tab, select secondary
axis.