Hi,

Here is a collection of examples of how to break the axis.

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/excel/newsgr...ial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

Jill wrote:
Most of my values range from 0 to 300, but one value is 1200. I would like to
graph the values 0 thru 300 in detail, and have a "break in the graph. After
the break I would like to start a scale from 1000-1200, to graph the
remaining point. Does anyone know how to do this?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info