Compressed part of an axis

  • Thread starter Thread starter haagen.waade
  • Start date Start date
H

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
 
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
 
Back
Top