different scale on x-axis

[katy]

just wonder how can i change the x-axis value to different values in the same
chart?
e.g 0-->120 (within this range...the graph shows major unit such as 10, 20,
30, 40 etc....) then 100--> 1000 the graph just shows 200, 300, 400 etc as
major unit~

 

[Andy Pope]

Hi,

You would have to construct you only axis labeling.
See Jon Peltier's page on arbitrary axes
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Cheers
Andy

 

[ShaneDevenshire]

Hi Katy,

One common way to handle such problems is to use a Log scale for the axis.

Double click the axis and choose the Scale tab, check Logarithmic scale