Graph with large data range (hash marks on axis)
 

I am doing a simple XY chart but one value is significantly larger than
others on the axis. I've seen charts where the axis has hashes: // when the
values on the axis are for example 1, 2, 3, 4, // 15, 16, 17.

Is there a way to do this in Excel?

Graph with large data range (hash marks on axis)
 

Try this:

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

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


"cebceb122" wrote in message
...
I am doing a simple XY chart but one value is significantly larger than
others on the axis. I've seen charts where the axis has hashes: // when
the
values on the axis are for example 1, 2, 3, 4, // 15, 16, 17.

Is there a way to do this in Excel?