Compressed part of an axis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

haagen.waade@gmail.com - 28 Nov 2005 09:53 GMT

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

Reply to this Message

Andy Pope - 28 Nov 2005 10:08 GMT

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

> Is it possible to get Excel to compress a part of an axis, while let
> the other part have the axis expanded.
[quoted text clipped - 7 lines]
> TIA,
> Haagen

Signature

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

Reply to this Message

Jerry W. Lewis - 28 Nov 2005 11:34 GMT

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

> Is it possible to get Excel to compress a part of an axis, while let
> the other part have the axis expanded.
[quoted text clipped - 7 lines]
> TIA,
> Haagen

Reply to this Message