Secondary axis for LINE charts

[asma410]

Hello!
I am trying to generate a secondary axis (vertical) for my line chart but the axis is automatically added on the right along with the primary axis & its difficult to differentiate between the two. Is it possible to separte the secondary & primary axes in a line chart? I want the secondary axis to show on left & primary on the right. The only way I am able to separate them is by using BAR graph for one series & LINE for another. I want line chart for both the series & show vertical axes on left & right.

I appreciate any responses.
Thanks

 

[GlennUK]

Select the horizontal axis and format it, set Axis Options making "Vertical Axis Crosses" option be Axis Value of -50.

 

[asma410]

Thanks a lot GlennUK. PERFECT solution!!

 

[GlennUK]

My pleasure.