Access line chart issue

[SysTech]

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?

 

[Bernard Liengme]

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

 

[ShaneDevenshire]

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.