different scale on x-axis

K

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

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
 

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

Top