Plot both series on the chart. Then, double-click the series you want on
the secondary (right) axis, and in the resulting dialog box, from the Axis
tab, select 'Secondary'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article .com,
says...
Hi,

I'm using xl'97 and I'm trying to chart 2 different tables to 1 chart.
To do this I would need XL to display 1 scale on left and another one
on right sided of the chart and then chart both tables to 1 chart.

Is this possible ?

Thanks for help,
Sirritys