Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |