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~

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~

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
--
Cheers,
Shane Devenshire


"katy" wrote:

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~