software

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.

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:

peltiertech.com/Excel/Charts/BrokenYAxis.html

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

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