Compressed part of an axis
 

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

Compressed part of an axis
 

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

Compressed part of an axis
 

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

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