see http://peltiertech.com/Excel/Charts/BrokenYAxis.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rave" wrote in message
...
I am charting 7 departments however 1 department has a large number to
chart
which brings down the other departments. How do I make a break in the y
axis
at a certain numerical value and then continue on at a higher value.????