Excel graphs with Access database
 

I have a problem and have just about gotten to my wits end on how to
make this work.

For a project at work, I need to be able to produce a graph of some
data in an Access Database. This database has several fields which are
similar to "Are you satisfied with our service?"-type questions and is
filled with 1 of 6 possible responses: "Excellent", "Good", "Fair",
"Poor", "No Opinion", or blank entry.

What I need is a way to count up all the Excellent responses for each
of these fields, count up the Good responses, count the Fair responses,
etc., and then generate a bar graph for each field and a visual
representation of these counts.

So far, I've had little success in generating this. The closest I got
was to import the data into Excel, and try producing a graph there,
which worked, but it wasn't pulling the right data in the right way.

I'd appreciate any help!

Thanks!

Excel graphs with Access database
 

What form did the data take when you imported it into Excel? Did you
have the questions in one column (repeated many times) and the
responses in another column, or were the responses in 6 separate
columns? If in one column, did you have words like "Excellent", "Good",
"Fair" etc, or were these abbreviated or coded in some way (like 1 for
Excellent, 2 for Good etc) ?

If you could give us some more details I'm sure someone will be able to
come up with a solution to suit your specific problems.

Pete

Excel graphs with Access database
 

OK, the database, like I said has multiple columns and some of them
have pre-determined selections in a drop-down box. These fields are
mixed in amongst other free-form text fields. I need to generate a
series of bar graphs that show the number of each possible response for
these fields. The fields are named according to the possible responses
on a written survey. So, you might have a question that says "How do
you feel about these aspects to your job:", then a sub-question that
asks "Pay is good", and then possible reponses of "Excellent", "Good",
"Fair", "Poor", "No Comment". Here is how the data looks in the
database:

Name |Pay |Working Conditions
|Advancement Opportunities
-----------------------------------------------------------------------------------------------------------------------------------------------
John Q. Public |Excellent |Fair
|Good
Jane Q. Public |Poor |No Comment
|Good
Jim Q. Public |Excellent |Good
|(blank)

These fields are mixed in with other text fields to handle comments for
each of these questions. Each record also has an index value. I have
also created a table that only has a single field and contains the
possible responses to these questions, i.e.

| Field
------------------
|Excellent
|Good
|Fair
|Poor
|No Comment

I suppose the question to ask instead of how to fix what I've done, is
how to make a series of bar graphs to show the number of each possible
response to each of these questions. When I try to import, I use the
PivotTable and PivotChart wizard, external data source, Get Data, MS
Access Database, select the .mdb file on the network, then it asks me
what columns I want to include. I think this is the point that I'm not
sure of what to do. Any help is appreciated.

Thanks!