Suzan -
Scatter charts treat each X "value" as a value, while Line charts treat
them as nonnnumeric category labels (or date values). If you want evenly
spaced labels regardless of value (distance from 31.5 to 64 same as from
64 to 192), use a line chart, and format the series to remove the lines
connecting the points.
If you want the axis to represent the numerical values of the X data,
but want a tick only where you have a point, add a dummy series to the
chart. This series uses the same X values, but zero (or whatever is the
Y axis minimum) as Y. This series then has a set of points along the X
axis of the chart. Hide the regular axis ticks and labels (double click,
Patterns tab, option None where appropriate), format the new series as
black crosses, to mimic tick marks, and apply data labels (the Show
Values option) to put pseudo tick labels beneath these pesudo tick marks.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______