Thread: 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?

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


jeffnoll <jeffnoll.1kkd00@excelforum-nospam.com> wrote in message
news:jeffnoll.1kkd00@excelforum-nospam.com...
>
> 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?
>
>