I have created two charts, both of which have a data table attached. The first gives a % score by region from Apr 2005 to Mar 2006 and orders them accordingly.

The second gives an average score for each location by region from Apr 2005 to Mar 2006. However this chart sorts the month alphabetically so it goes Apr, Aug etc. The underlying query is sorted on date order ie 24063 for Apr 2005, 24063 for May 2005 and so on. Is there a way to force it to sorted by date order but display the actual date?

The row source for the chart is "TRANSFORM Sum([Average score]) AS [SumOfAverage score] SELECT [Location] FROM [% cases seen by region and location] GROUP BY [Location] PIVOT [Month];"

I've tried to add a GROUP BY [month order] statement at the end but this has not worked although I'm not sure I got the syntax correct. Is it not possible to display the date but sort by something underlying like month order and hide it?

Thanks!

Create 2 calc fields in your query; one would be Year(datefield) and the other Month(datefield) and sort on both fields; record will be sorted my year then my month numerically.