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

Robert11 wrote:
> 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, Microsoft MVP - Excel
http://www.andypope.info