Splitting the y-axis
 

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.

Try this:

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

"mem" wrote:

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.

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/newsgr...xis/index.html

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


mem wrote:

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.

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