View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default scale on scatter

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tom Jacobs" wrote in message
oups.com...
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