Varying axis scaling

[jeffnoll]

I'm trying to do a some pump curve graphs using a scatter plot. The
problem is that there are both low end and high end curves that I'm
trying to place on the same chart and the distances between the two are
fairly large.

What I want to do is have a varying scale for the x/y axis

For example, for values
x from 0 - 1000 a tick of 50
1000 - 4400 a tick of 200

y from 0 - 1000 a tick of 100
1000 - 2000 a tick of 200
2000 - 15000 a tick of 1000

Is this possible?

 

[R.VENKATARAMAN]

try using secondary x and y axes. see Jon Peltier's and Tushar Mehta's
webpages.(not tested)

 

[Jon Peltier]

Jeff -

You could also try this approach:

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

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