In Excel, this data plotted just fine for me with the x-axis going from Jan
to Aug. I assume, that like me, you use the international (not US) date
format.

If this were an Excel question (not Access) I would suggest you right click
chart, select Chart Options and open the Axes tab; now ensure the x-axis is
set for either Automatic or Time Series

If this does not work, I would check that I had real dates in the x-values
(not text)

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SysTech" wrote in message
oups.com...
I want to create a line chart on access 2003 between the time line
based on a query. The query results are the number of incident each
day. So the query result looks something like this:

1/1/2006 5
1/2/2006 3
1/4/2006 4
1/8/2006 7

The problem is if there is a gap between dates, the line chart wouldn't
go to zero. It would just jump from last data point to the next when
the time-scale axis is used. How do I make the line chart to go to zero
when there is no data for that date. Can someone please help?