Chart Axis Showing Lapse/Interupt Scale

[Guest]

I am using the columns with 2 lines chart and my data on the X Axis is number
of events and time for the event. The Time for the event runs from 0 to 2500
minutes, but I only have one event that is greater than 2000 minutes. I'm
trying to create a scale where I have 0, 500, 1000, then want to skip to
2000, 2500. Is there a way to change this scale so that the other event
times such as 6, 247, 577 would appear and then the other 2200 time interval
would be plotted. Not even sure I'm describing this correctly. I think
I've seen this before and the indicator on the X axis has been a double tick
mark to indicate something has been skipped/adjusted. I'm hopeful by doing
this, my event times of 6, 247, etc. will show a little more clearly.

 

[Jon Peltier]

There's no built-in way to break an axis, but there are lots of workarounds.
Here's one technique, which has links to others at the end:

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

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