This worked:
  • Right click on one of the dataset lines in the chart
  • It should get some sizing blocks on it, then select Change Series Chart Type
  • When the dialog box opens, change to a regular bar chart (top leftmost selection)
  • Click OK
  • Right click on the new dataset (on one of the bars), select Format Data Series
  • One of the selections on the left should be Series Options, and one of the options in that group should be ‘Plot Series On’…and Primary Axis should be selected
  • Choose Secondary Axis
  • It should duplicate the ‘Y’ axis on the opposite side from where you have it set.
  • Don’t panic about the formatting, it’s pretty easy to format it after the fact.
  • Then you just reverse the process to set the chart type back.

Thanks much, this is a great resource...

mksnyder