Try adding a helper column to your worksheet. Assuming your dates start in
cell A1 and the helper column is column B, add this formula to cell B1:

=TEXT(A1,"mm/dd/yyyy")

Copy this formula to include your X-axis range. Then, change your chart
reference for the X-axis to include column B as opposed to column A.

The formula changes the date reference to text.

--
John Mansfield
http://cellmatrix.net




"Haz" wrote:

Thanks Jon - but I'm not sure what you mean by 'general alignment'. My
dates are of the mm/dd/yy format, right justified. I am already in the
Time-Scale option, but my as-plotted data points are way off the correct x
axis (date) value.

Haz

"Jon Peltier" wrote in message
...
Excel may not recognize your dates as dates. Make sure they are numeric
dates (with general alignment assigned, they will be right aligned in the
cell). Then go to Chart menu Chart Options Axes tab, and select the
Time-Scale option under Category X Axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Haz" wrote in message
...
I'm having trouble with irregularly spaced dates. Two questions:

1) How can I get my data to plot at the correct location on the x axis,
that is, between grid lines when necessary? (I have numerous gaps in my
dates so I chose the 'interpolated' option.)
and 2) Let's say I have two sets of date data, one starting in January,
the second in June. The second plot wants to start at the January grid
line - how can I get it to start at June (really same problem as #1 I
guess.)

Any suggestions would be appreciated.

Haz