Multiple Y-Axes 2

[Creigbm]

Is there a way to have two y-axes? I am trying to lable Moment up the left axes and force up the right so I can place all the data on one plot. Thanks in advance for any help.

 

[jmw]

Double click the data curve you want to move.
The window that opens gives you the option to select the primary or secondary axis.
Then double click each axis in turn and adjust the scale to suit.
But that's about as far as Excel goes, to my knowledge. I would love to be able to plot different parameters against multiple independent axis so if there is an answer to that, I'll be interested.

JMW

http://www.viscoanalyser.com

Eng-Tips: Pro bono publico, by engineers, for engineers.

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips Fora.

 

[Creigbm]

Thanks for your help.

 

[bltseattle]

It might depend on which version of Excel you have. For Excel 2002 you can:

Click & select the series you want to have the second axis for. Go to menu item "Format selected data series". Click the axes tab in the dialogue, then check "Secondary axis" option.

 

[joerd]

Take a look at Jon Peltier's site. He has all the chart tricks!

http://peltiertech.com/Excel/Charts/index.html

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[jmw]

Joerd,
a very useful link!

JMW

http://www.viscoanalyser.com

Eng-Tips: Pro bono publico, by engineers, for engineers.

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips Fora.