Issue with sorting (pic incl)

[AUGuy]

So here's my dilema...

As you can see, the crosstab SQL statement that feeds this query doesn't let me sort the date column headers with anything aside from ascending/descending. This causes problems highlighted in yellow where in 2011, Aug is before the other months. Is there a way around this?

Here is the SQL feeding one of the 3 charts:

TRANSFORM Sum(Round([SumOfCount],1)) AS Expr1
SELECT [AAG - Management (incl ORE) - Historical].Management
FROM [AAG - Management (incl ORE) - Historical] INNER JOIN [Date Exclusions] ON [AAG - Management (incl ORE) - Historical].ShortDate = [Date Exclusions].[Short Date]
WHERE ((([Date Exclusions].Exclusion)<>"Exclude"))
GROUP BY [AAG - Management (incl ORE) - Historical].Management, [Date Exclusions].Exclusion
PIVOT Format([ShortDate],"'yy mmm");

 

[vbaInet]

It's been a while since I touched charts in Access so I would need to see the db to be able to advice. Upload a stripped down db so we can tweak things round.

 

[AUGuy]

Unfortunately, I can't upload files from my work PC. The functionality is blocked via IT. It wouldn't be difficult to replicate, the chart is tied to a crosstab with date/category/and balance data. The dates make up the columns of the crosstab which is what I'm trying to sort in the data table attached to the graph.

 

[vbaInet]

I'm not at liberty to replicate your db. Limited time you see

Copy it to a flash drive, import the relevant bits with some bogus data into a new db, strip off irrelevant bits, go to a machine that allows upload and post the new db.