different scale on x-axis

G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart with differing x axis 1
Help on logarithmic scale 1
Negative values on X axis 6
Auto Scale x-axis 1
How to set scale of y axis for time 4
Formatting 'X' Axis -- 2 fundamental differences 7
Constant % on X axis 2
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0

Top