Broken X axis

[LT]

I'm trying to chart a stress-strain curve in excel, and I
haven't been able to show 2 scales on the x-axis, one for
the low range, 0-0.002, and another for the high-range
0.002-.6. Any help with this would be appreciated.

 

[Jerry W. Lewis]

Excel does not natively support broken axes. Tushar Mehta has
directions for simulating a broken y-axis

http://www.tushar-mehta.com/excel/newsgroups/broken_y_axis/tutorial/index.html

that you might be able to adapt.

Jerry

 

[Jon Peltier]

I have one as well:

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

- Jon