View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?