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