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

"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.

[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/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.

[fernando cinquegrani]

In news:[email protected],
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