I am trying to add a pie chart to a report that will display the total check boxes checked in a table. I have 110 things I need to examine, and I need to know what percent have been checked by category of "Satisfied", Not Satisfied" and "Not checked yet". I have a query that does the following:
Field 1 - Counts the total number of records, which never changes
Field 2 - Counts the number of times in the record set that the "Satisfied" box was checked
Field 3 - Counts the number of times in the record set that the "Not Satisfied" box was checked
I need a pie chart that uses Field 1 as the total (100%) for the pie chart and Field 2 and 3 are separate pie slices of the total that have been checked. No idea how to build that chart...
Thanks!