Something like this?

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

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Jen" wrote in message
...
How do you expand/adjust the first tick mark on the Y Axis to display or
zoom
in on a smaller number in a chart with mainly large numbers.