Line Chart Report with 2 Different Scales?

I have a line chart with two lines in it. Sometimes the values between them differ by a hundred or more. That leaves the bottom line looking very flat. I want both of these to remain 开发者_开发百科on the same graph but is there a way to have a different scale for each line?

I was told that it is possible to have one (scale) on the left and one on the right, but I have googled and googled and have not found anything useful.

So any help would be great, thanks!

In the properties for the chart series change the ValueAxisName to Secondary

OR

1. Right-click on the chart series
2. Goto Series Properties
3. Goto Axes and Chart Areas
4. Change the value Axis to Secondary