switch order of double y axes (left-right)?

[studentcanada]

Hello all...I'm new to this so bear with me.

In a scatterplot graph, I have two y axes, and want to display what is now the right y axis as the left one (as it has more importance to the display), and what is now the left y as the right. No matter what order I add the series in, I still get the same left-right relationship.

Anyone have any ideas?

 

[Juan Pablo González]

Hi, welcome to the board.

I think that all you need is order in your steps...

For example, I have two series in my chart. One on each axis of course...

So, I double click on the serie that is on the second y axis (blue), and in the 'Axis' tab, change it to be on the first axis.

Now both series, blue and red, are on the first axis.

Finally, double click on the red series, and change the axis to use the second axis.

Then you should get the expected results !