How to break the Y axis in an Excel sheet

I want to break the Y-axis in an Excel sheet. How can I do that?

For example, suppose I have the data in a range from 0-7000 and then range from 22000-28000. I want a break in the Y axis from 8000-20000.

Solution 1:

You cannot break the y-axis on an Excel chart to show several, non-contiguous ranges but you can change the default range by right clicking on the y-axis and selecting Format Axis... and then changing Minimum and/or Maximum from Auto to Fixed then supplying new values.

Solution 2:

I agree with @JonPeltier's point of doing this being a bad idea, conceptually. However, if you must, there is a simple solution.

Graph the entire range and save or capture the graph as an image. Open the image in an image manipulation program, like Photoshop or GIMP. Then cut out the area you don't want, move the upper range closer, and add jagged lines to the Y axis at the edges of the break to indicate the discontinuity.