OR... in the query, concatenate "CDate(#1 " on the front and ")#" on the back of those dates, then plot an X/Y scatter graph. If you convert the text dates to date-format data, the chart will go in the correct order.
OR... in the query, concatenate "CDate(#1 " on the front and ")#" on the back of those dates, then plot an X/Y scatter graph. If you convert the text dates to date-format data, the chart will go in the correct order.
This seems like the better option but I cannot seem to get it to work, this is my SQL:
SELECT [2022 Monthly Totals].[Budget Month], CDbl([SumOfBudget]) AS Budget, CDbl(Nz([Sum Of Home Currency (USD)],0)) AS Actual
FROM [2022 Monthly Totals] LEFT JOIN [tblExpenses Query1] ON [2022 Monthly Totals].[Budget Month] = [tblExpenses Query1].[Date By Month]
ORDER BY CDate("1 " & [Budget Month]);
What that does is bracket the date with octothorpes (a.k.a. pound sign). You had a text field, which is not a date, so you needed to bracket BOTH sides of the text field with the # character and convert THAT to a date.