How to have the Y axis labels on both ends of the chart?

[JenniferMurphy]

I cannot find a way to have the vertical axis labels on both ends of the chart. Is this possible?

I tried following several sets of instructions for creating secondary axis, but it always seems to screw up the data.

I know how to move the axis from the left to the right. That's not what I want. I want it on both ends.

Thanks

 

[JV0710]

Good Day

Add another series with the same data and place it on the secondary Y-Axis

 

[JenniferMurphy]

Good Day

Add another series with the same data and place it on the secondary Y-Axis

If you mean go to Select Data and add a series by selecting one of the existing data columns, I tried that, but then I get another plot on the chart.

 

[JV0710]

yes. you would need to format the second series no fill, lines etc