Dual Y Axis in Line Plots
 

How can i plot line graphs having dual Y axis at two ends? The two Y axis
have to be of different scales in the same plot.

Dual Y Axis in Line Plots
 

amitsaurav wrote:
How can i plot line graphs having dual Y axis at two ends? The two Y axis
have to be of different scales in the same plot.

If you've set up to plot two lines, using the XY plot format, then:

1) Right click on one of the lines to highlight it,
2) Click on "Format Data Series"
3) Select the "Axis" tab
4) Click on the "Secondary axis" radio button

Bill

Dual Y Axis in Line Plots
 

Thank You Mr Martin. Your reply helped me solve my problem.

Dual Y Axis in Line Plots
 

And mine too! Thanks!

Dual Y Axis in Line Plots
 

How does this work in Excel 2007?

"Bill Martin" wrote:

amitsaurav wrote:
How can i plot line graphs having dual Y axis at two ends? The two Y axis
have to be of different scales in the same plot.

If you've set up to plot two lines, using the XY plot format, then:

1) Right click on one of the lines to highlight it,
2) Click on "Format Data Series"
3) Select the "Axis" tab
4) Click on the "Secondary axis" radio button

Bill