Hi,

Assuming you are using the Microsoft Graph feature, not the PivotChart, when
you are in the chart editing mode choose Tools, Options, Chart and make sure
the Cells plotted as is set to Not Plotted.

Personally, I strongly recommend that you chart in Excel rather than Access.
--
Thanks,
Shane Devenshire


"SysTech" wrote:

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?