Alternate method

  1. On the Chart tab, in the Series group, click the dialog box launcher.
  2. From the Series list, use the arrows to select a series.
  3. Select the Scale on 2nd Y axis check box.
  4. Click OK.
  5. Click Save Changes.