scale on scatter

T

Tom Jacobs

hi

i have tried a few ways to alter the scale on the x axis of a scatter
graph but so far not found a way to do it as i would like.

my data point are at: 2 4 8 16 32 64 etc
i want the axis to start at 2 but have major markers at 8 16 24 32 etc
(8 seperations)

the problem is when i set the min to 2 i cant get the divisions to line
up with 8 16 instead they are 10 18 etc

if i set the axis to min 0 and set the axis cross bit to 2 i get a
horrid bit to the left of the axis which i do not want.

does anyone know how i can set the axis to a point but not have it
going to the left of the axis.

many thanks


ps while i am posting i will ask another quick question. does
anyone know how to get thesqiggle on the axis by 0 to show that there
is a break in the scale ie 0 sqiggle 42 44 46 etc? thanks
again
 
B

Bernard Liengme

You cannot have ticks at 2, 8, 16, 24 since the separation for the first
pair is 6 but 8 for the other pairs. Why not start at 0?
Format the axis. On the Scale tab specify Min and Man values and set Major
Units to 4.
best wishes
 

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