2 data sets on 2 y-axis

[lewis_green]

Hi there, I have a simple problem that has probably been asked a thousand times, so for that I apologise! I have searched for quite a while on the board however, and have not managed to find a solution.

I am using Excel XP Professional.

I want to present two sets of data on the same graph, for example this sort of data:

month eggs bacon
jan 15 10000
feb 8 20000
mar 7 30000
apr 12 40000
may 4 50000

eggs and bacon however, are clearly very different scales, and I want this to be reflected on 2 different y-axis with scales 0-20 and 0-50000 being the same height (if that makes sense). Any ideas?

Many thanks in advance for your kind help.

 

[VoG]

On the chart, right click a plotted item, and then click Format Data Series. Click the Axis tab, click Secondary axis, and then click OK.

 

[lewis_green]

Thanks ever so much!