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 <(E-Mail Removed)>,
(E-Mail Removed) 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
>
>