Chart Legend

[Geoff Codd]

I have the following SQL to create a chart

SELECT (Format([Month],"mmm"" '""yy")) AS Expr1, Sum([Est v Act (All Companies & All Months)].Actual) AS SumOfActual, Sum([Est v Act (All Companies & All Months)].Estimated) AS SumOfEstimated
FROM [Est v Act (All Companies & All Months)]
GROUP BY (Format([Month],"mmm"" '""yy")), (Year([Month])*12+Month([Month])-1);

The problem I have is that the legend shows sumofactual & sumofestimate and I want it to show Auctal & Estimated with a Title of Revenue

Any help greatly received
Thank you

 

[simongallop]

In your SQL change the AS SumOfActual to AS Actual etc.