Chart data with 2 different set of data on the same graph

[Wellie]

I have 2 set of data as shown in sample below:
Month Set-1 Set-2
Jan-04 9,203 12.4
Feb-04 7,012 09.2
Mar-04 8,321 11.2
Apr-04 8,801 08.4
May-04 9,001 10.6
etc

I need to chart them on the SAME graph using either Line,
Scartter ,Bar or Column(not pie chart). Due to the Set-
2's numbers are very small and it shows as a straight
line of dots at the bottom when I use either Line or
Scatter graph, or show only Set-1 data in Bar or Column
charts.

Can someone tell me if it is possible to use different
scale to show the data on the SAME chart ?

Thanks in advance for any help.

 

[Andy Pope]

Hi,

Yes you can use a secondary y axis.
Select the 2nd data series and right click. Pick the format object to
display the Format dialog. On the axis tab choose Secondary axis.

Cheers
Andy