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?

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

[Andy Pope] scrive in
.gbl
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?

also: http://www.prodomosua.it/zips/taglio.xlt
parameters: 25 (E2), 25 (E3), 13 (E5), 40 ((E6)
.f