Thread: Break in graph?
View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Ellen -

The web page describes how this is done for the Y axis, but it can just
as easily be applied to the X axis:

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

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

Ellen wrote:
Hello,
I'd like to chart some data where there's a gap in the graph. For instance,
the x-axis would start out 1, 2, 3, then go to 10, 11, 12, thus excluding the
data between 3 and 10. We'd like reader to focus on the data outside this
gap.

Is there a way to do this in Excel?

Thank you in advance,
Ellen