Multiple Y-Axes
Multiple Y-Axes
(OP)
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.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Multiple Y-Axes
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
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.
RE: Multiple Y-Axes
RE: Multiple Y-Axes
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.
RE: Multiple Y-Axes
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.
RE: Multiple Y-Axes
a very useful link!
JMW
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.