Why, oh, why does Microsoft Excel not offer simple one button click y-axis breaks?
For the last twenty years its always got my goat to see truncated bar or line graphs that misrepresent the underlying scale of the data series.
If you want to know how to do scale breaking in Excel then check this out:
If you want an alternative using panel charts then have a look at this:
Truncated graph A truncated graph (also known as a torn graph) has a y axis that does not start at 0. These graphs can create the impression of important change where there is relatively little change. Truncated graphs are useful in illustrating small differences. Graphs may also be truncated to save space. Commercial software such as MS Excel will tend to truncate graphs by default if the values are all within a narrow range, as in this example.