Showing Percentage of Completion on a graph?

[AngeloWolfe]

Greetings AW! I can always counton you guys to help me out when I'm having really wierd issues.

So, here's the scenario. I have a database (Database_1) that multiple users are using. The database works as a survey tool. The user has the option to view all of the surveys each participant has taken (The data is housed in tbl_1 in this example), or they can pull a form up and choose their name from a form, and it brings up a filtered query with just their surveys. The user then chooses from a DDL whether they approve, reject, or other. What I would like to do is have a bar / pie graph that shows the percentage of surveys that were approved, the percentage rejected, and the percentage of others chosen.

From what I've been able to gather, I should be able to use the "Insert Chart" control specify my category, series, and data but I'm not having any luck at all! I will have the "Survey Type" at the category, "Survey Choice" as the series, and -at the moment- a CountOfSurveyChoice for the data. Once I navigate to the "finish" page, a bar / pie graph is displayed that shows me (Q1, Q2, Q3, Q4) as the categories, and has a bunch of random numbers generated that does not reflect any of my data!

Any suggestions on fixing this problem will be greatly appreciated! If you need anymore information, just let me know.

 

[AngeloWolfe]

Oh, for clarification. I'm using Microsoft Access 2007

 

[AngeloWolfe]

Time heals all wounds. For the sake of seeming silly, I will go ahead and solve my own issue.

What I was not aware of is that when you first implement the chart, the data it shows is "example" data. When you go into Report view for the first time, it refreshes and updates the data given.

To display the percentages, it's still just as simple. You right-click on the bars/pie pieces / etc. and format data labels and choose "Percentages."

To find a % of completed for each of the different Testers, all that needed to be done was add a Calculation field in the query and it gave me the information I needed.

It's unorthodox, but it's solved, haha!