Hi,

There is no built in way to do this. You can create your own ticks and
labels. See Jon Peltier's page for examples of how to do this.
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Cheers
Andy

wrote:
Is it possible to get Excel to compress a part of an axis, while let
the other part have the axis expanded.
I.e:
y value 1 to 100 with a tick of 10, while value 100 to 1000 a tick of
100.

Is this possible in Excel, or does one needs SPSS or other packages for
this?

TIA,
Haagen


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info