Excel Line Chart Question

[philia]

I'm making a line graph from four columns of numbers. Two of the columns have two values of about 500,000 and then decline from there. The other two columns have values around 5,000 or lower. (I've given an example below.) So the obvious problem is that it's very difficult to see the shape of the lines, the spikes and curves, of the two columns with low values or, for that matter, to see the lines for the lower values of the two columns that have two value that peak around 500,000.

Questions:

Is there a way to zoom in on the chart to see the lower value area of the lines while preserving the x-axis values of 1-10? (That is, the X-axis here runs 1 to 10 and the peak values around 500,000 occur on a 1 and 10, respectively, on the x-axis--and I would like to see the lines running 1-10 on the two smaller columns.) Can you cut the chart so it doesn't go above, say, 100,000 or 50,000, vertically?

Thank you.

Sample:

1 500,000 1 33000 6689
2 200,000 244 38000 6781
3 100,000 131 45000 7231
4 77000 2222 66000 8342
5 62000 12000 66000 8543
6 22000 55000 63000 8691
7 34555 88000 33000 7236
8 345 125000 25000 6214
9 22 189000 22000 5154
10 1 477000 20000 4900

 

[AlphaFrog]

Here's a tutorial on how to make a broken or split Y axis.

Broken Y Axis

 

[VoG]

And another

http://www.andypope.info/charts/brokencolumn.htm

 

[shg]

Or you could plot one or two of the series on the secondary y axis with a different scale.