On the Y axis how do I make 0-100 big and then 100-500 small?

[Alcoa]

I have small numbers and then big numbers on the same chart. To better
represent all of the numbers I want 0-100 on the Y axis to be spread out,
showing a small intervals from each number, then from 100-500 I want the Y
axis to shrink and show large intervals between numbers

[Jon Peltier]

You can make a custom axis using a dummy XY series, then selectively rescale
your data to fit. Here are some examples of custom axis scales:

http://peltiertech.com/Excel/Charts/...tml#AxisScales

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

"Alcoa" <Alcoa@discussions.microsoft.com> wrote in message
news:92CB66D0-65F9-4A07-ABD7-1717D908EB40@microsoft.com...
>I have small numbers and then big numbers on the same chart. To better
> represent all of the numbers I want 0-100 on the Y axis to be spread out,
> showing a small intervals from each number, then from 100-500 I want the Y
> axis to shrink and show large intervals between numbers