Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
scale on scatter
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
Scale on X & Y Axis of the scatter chart | Charts and Charting in Excel | |||
X axis scale on an XY scatter plot | Charts and Charting in Excel | |||
Changing the scale major unit in a graph | Excel Discussion (Misc queries) | |||
Locking the scale ratio of X-Y axis in XY scatter charts | Charts and Charting in Excel |