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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"katy" wrote in message
...
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~