Splitting the y-axis

[mem]

Can I split the scale of the y-axis so that it jumps from a lower value to a
higher, e.g. value of 80 to 300 to account for a few large data points I
have? This would be like putting a 'wiggle' in the axis.

 

[Barb R.]

Try this:

http://peltiertech.com/Excel/Charts/axes.html#Broken

 

[Jon Peltier]

I have an example on my web site:

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

and so do Andy Pope and Tushar Mehta:

http://andypope.info/charts/brokencolumn.htm
http://tushar-mehta.com/excel/newsgroups/broken_y_axis/index.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[fernando cinquegrani]

In mem scrive:

Can I split the scale of the y-axis so that it jumps from a lower value to a
higher, e.g. value of 80 to 300 to account for a few large data points I
have? This would be like putting a 'wiggle' in the axis.

take a look:
http://www.prodomosua.it/zips/taglio.xls
.f