Excel Axis Formatting

[AccessUser22]

If I have a range of numbers such as follows:

5239
2181
989
568
420
203
161
44

I want my graph to show the first 1000 axis ticks as 0, 100, 200, 300, etc. Then above 1000 I would like the axis ticks to be 1000, 2000, 3000, etc.

Is there any way to set this up? Any advice is appreciated.

 

[xlhelp]

Right click on axis, choose Format Axis, scale Tab. Use Logarithmic scale.

Your chart will now be non-linear if it was linear before.

Member- AAAA Association Against Acronym Abusers

 

[AccessUser22]

That only works if I want a logorithmic axis. I don't necessarily want the data graphed logarithmically. And it doesn't set the axis up the way that I need.

 

[SkipVought]

Hi,

The you'll have to set up TWO charts;

First chart MAX SCALE of 1000
Second chart MIN SCALE of 1000

and stack them

Skip,

_[red][/red]