break in chart scale

[Guest]

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]

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/newsgroups/broken_y_axis/tutorial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

 

[fernando cinquegrani]

[Andy Pope] scrive in
http://www.google.it/groups?threadm=#[email protected]
also: http://www.prodomosua.it/zips/taglio.xlt
parameters: 25 (E2), 25 (E3), 13 (E5), 40 ((E6)
.f