Percentage Charts in Access

[jammin140900]

Hi experts,

Just need to put together a chart (perhaps pie would be best) to show the percentage breakdown of all auditors results (their are 4 categories) out of the total number of audits for that company. I have the query working well, however, I have no idea to relay it in a chart.

Here's my query

SELECT tblRTO.TrainingOrganisation, Round(((Sum(IIf([AuditResult]="Compliant",1,0))/Count([AuditNumber]))*100),2) AS [Compliant %], Round(((Sum(IIf([AuditResult]="Minor Non-Compliant",1,0))/Count([AuditNumber]))*100),2) AS [Minor Non Compliant %], Round(((Sum(IIf([AuditResult]="Significant Non-Compliant",1,0))/Count([AuditNumber]))*100),2) AS [Significant Non Compliant %], Round(((Sum(IIf([AuditResult]="Critical Non-Compliant",1,0))/Count([AuditNumber]))*100),2) AS [Critical Non Compliant %]
FROM (tblEvents INNER JOIN tblRTO ON tblEvents.TOID = tblRTO.TOID) INNER JOIN tblAuditing ON tblEvents.ChecklistID = tblAuditing.ChecklistID
GROUP BY tblRTO.TrainingOrganisation
HAVING (((tblRTO.TrainingOrganisation) Like "*Australian Wool*"));

I've always avoided charting in Access before as Excel is so much friendlier about this! Could you please explain how to do this in a chart? I have tried the pie chart but it gives me- in fact I don't know what its trying to return!

Thanks
Mark