Using Right Hand Y Axis For An Additional Variable: How ?

[Robert11]

Hello:

Using an older copy of Excel,"Excel 97"

However, it's been working just fine, and pretty much does everything I
want.

A bit stumped on this, however:

I would like to generate a graph/chart that plots 2 variables along the
normal Y axis, but in addiition
I would like the right hand Y axis to be used for a third variable.

The Scatter or Line type(s) would be fine.

Can't quite come up with how to do it.

Is it possible ?

Thanks,
Bob

 

[Andy Pope]

Hi Bob,

Add your 3rd data series to the chart then double click it.
On the Axis tab select use secondary axis.

Cheers
Andy