Varying axis scaling
 

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?


--
jeffnoll
------------------------------------------------------------------------
jeffnoll's Profile: http://www.excelforum.com/member.php...o&userid=20023
View this thread: http://www.excelforum.com/showthread...hreadid=346088

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


jeffnoll wrote in message
...

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?


--
jeffnoll
------------------------------------------------------------------------
jeffnoll's Profile:
http://www.excelforum.com/member.php...o&userid=20023
View this thread: http://www.excelforum.com/showthread...hreadid=346088

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/
_______

jeffnoll wrote:

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?