Compressed part of an axis

[haagen.waade]

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]

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

 

[Jerry W. Lewis]

With a linear scale going to 1000, the 10's ticks would practically
merge together. Dobule click on the axis; from the Format Axis dialog,
select tab Scale tab and check Logarithmic (leave all scaling
automatic); select the Patterns tab and set Minor tick marks to display
Outside of the axis. Is this the look you were wanting?

Jerry