How do I put a break in an axis in a chart?
 

Is there any way to put a break in an Excel chart axis? I'm using Excel 2003
and Excel XP. I have some graphs where one or more data points is
substantially higher than other data points; it's difficult to see the
differences between the lower data points. What I would like to do is have
the y-axis go from about 0-20, have a break in the graph, and resume the
graph at about 40 (my highest data point).

How do I put a break in an axis in a chart?
 

Here's an example and some links to others:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


pieridae3 wrote:

Is there any way to put a break in an Excel chart axis? I'm using Excel 2003
and Excel XP. I have some graphs where one or more data points is
substantially higher than other data points; it's difficult to see the
differences between the lower data points. What I would like to do is have
the y-axis go from about 0-20, have a break in the graph, and resume the
graph at about 40 (my highest data point).