# Excel Line Chart Question

#### philia

##### New Member
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

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Here's a tutorial on how to make a broken or split Y axis.

Broken Y Axis

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

Replies
0
Views
85
Replies
2
Views
169
Replies
1
Views
261
Replies
0
Views
314
Replies
6
Views
660

1,196,079
Messages
6,013,309
Members
441,760
Latest member
Sharina

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back