Problem to display date on chart..the date displayed as mmm yyyy.

[awinnn]

Hi,
I want to display no of staff with date on the chart. This is the sample of data,

NoStaff(Y) Date(X)
2 03/01/2004
1 08/01/2004
3 12/02/2004
1 23/02/2004
6 09/03/2004
2 12/03/2004
4 19/03/2004

But when i preview the chart, it goes like this,
(Y) (X)
3 Jan 2004
4 Feb 2004
12 Mar 2004

Any idea?
Thanx in advance..

 

[SuicidED]

Hi in your row source change it to
SELECT (Format([Datex],"dd/mm/yy")) AS Expr1, Sum(Table1.NumberofStaff) AS SumOfNumberofStaff FROM Table1 GROUP BY (Format([Datex],"dd/mm/yy")), (Year([Datex])*12+Month([Datex])-1);