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

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

[email protected] 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

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

[email protected] 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