How to Do Scale Breaks on a Graph in Excel

1. Launch Microsoft Excel 2010.
2. Click the 'File' tab at the top-left corner of the window, click 'Open,' then double-click the file containing the graph that you wish to edit.
3. Click the worksheet tab at the bottom of the window on which the graph is displayed.
4. Click anywhere on the graph to open the 'Chart Tools' utility.
5. Click the 'Layout' tab under 'Chart Tools' at the top of the window.
6. Click the 'Axes' drop-down menu in the 'Axes' section of the ribbon at the top of the window, click the axis (horizontal or vertical) containing the scale that you want to adjust, then click 'More Primary Horizontal Axis Options' or 'More Primary Vertical Axis Options,' depending upon which axis you are editing.
7. Click 'Axis Options' at the left side of the window.
8. Click the 'Fixed' option to the right of 'Major Unit,' then change the value to your desired scale break.
9. Click the 'Close' button at the bottom of the window to apply your changes.