Pie Chart

[Etaylor83]

I want to create a pie chart from an Access table.
I have a number of queries which are allocated to certain people under a
field called "Allocated to" and this then contains peoples initials next to a
query they are working on. This same column also shows resolved if a query is
resolved.
However i want a Pie chart to show a very basic statistic of
Allocated
Non Allocated
Resolved
with no initials or information - just a general number of all queries
allocated, all queries still outstanding and all queries resolved.
Is this possible.

 

[Duane Hookom]

Charts are hosted on forms or reports. You haven't mentioned either of these.

Typically you should create a query that displays the data you want in your
chart. Then insert a chart control onto your form or report.

The key to charts is the Row Source. Access has a tendency to muck up this
property so you need to edit it manually.