Break in graph?
 

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

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

Thanks, Jon. You obviously put a lot of work into this solution. I'm sure
it'll work. I'll need to study what you did.

Blessings to you!

Ellen

"Jon Peltier" wrote:

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