Create 2nd Y-Axis

To utilize the second Y-Axis feature, you will need to create a pivot table that contains at least two measures, then create a chart from the pivot table as usual, but change the Measure from a single measure to multiple measures:

Select at least two measures

At the legend click on the measure to select a different chart type