making graphs in Excel with two different scales?

Question

Does anyone know how to make a line graph with two different scales. I want to make a graph which shows how rainfall affects water level, but because rainfall varies by a factor of 20 and water level only rises by about 0.8 the water level graph just looks like a straight line when just one scale is used. I basically want a graph which down one Y axis has a scale of 0 to 1 and down the other a scale of 0 to 20.

Thanks for your help

Answer 1

Sure, create your graph the way you normally would, and then right-click on the line you want to display on the second axis (eg water level). Select 'format data series'. In the box that opens up click on the 'axis' tab. Select 'secondary' in the radio button.

There you go. And you can now format the scale, etc of that axis by right clicking it.

Edit: Apologies to Howard, but neither of his suggestions achieve what you want to achieve.

Answer 2

Seems like you have 2 options,
1. Plot two seperate charts.
2.plot on the same chart but scale your data
"1/20 * RF or 20*WL" , in other words multiply each cell in Excel by your scaling factor.
If you scale your model, you can show trends clearly on one chart. But make sure you state that you scaled it, in your plot.

Answer 3

so which you prefer 2 graphs on one sheet purely use the chart wizard and save it on comparable website for the two and decrease all of it the way down to in good condition or you may upload 2 sequence one for money and proportion on one graph and that they would be colour coded with a lengend.