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