Charts

dpw

Registered User.
Local time
Today, 23:20
Joined
Nov 13, 2000
Messages
21
I'm attempting to plot monthly statistics on a bar chart (in a form) for data over the past 3 years.

I would like to compare the data for each month. i.e. Jan 2000, Jan 2001, Jan 2002 'bars' next to each other and NOT Jan '00, Feb '00 etc through to Nov '02, Dec '02 as I keep getting.

Thanks

D
 
Try basing your chart on a query that has a calculated date field that gives you the correct sort order.

e.g.

SELECT Format([Table1]![DateField],"mm/yyyy") AS DateSortOrder, Table1.DateField
FROM Table1
ORDER BY Format([Table1]![DateField],"mm/yyyy");
 

Users who are viewing this thread

Back
Top Bottom