Percentages

[SteveAudus]

I am having problems using graphs in Access report and was hoping for some help.

The bar graph I have so far shows the number of good / bad or not bad, responses to a question. Each is grouped into the school returning the answers.

E.G
School 1, shows 20 good 10 bad 5 not bad
School 2, shows 15 good 5 bad 5 not bad
School 3, shows 5 good 2 bad 5 not bad

The graph I have shows each school next to each other on one graph.

But I'd like it to show the percentages of responces for each school, not the number of reponces.

I go to chart options and under data labels "show percent" is grayed out. I can only get "show percent" on if I change to chart to a pie chart. Then it just a one color pie chart that I can't make sense of.

Any suggestions?

Also, when the chart is sorted is there a easy way of getting it to reproduce to graph for the other questions in my questionaire, without copying the chart and going into the properties and changing the field in the Row source SQL Statement : Query Builder?

Any Suggestions?

Thank you any help given.

Steve Audus
Chaucer Community School, UK

http://www.chaucer.sheffield.sch.uk

http://www.educationinternet.co.uk

 

[bethabernathy]

Hi Steve - Can you email me your database so I can take a look at the chart in question. I seem to have trouble understanding the questions without seeing the database. It does not look like you can show a percentage with the graph chart, but you should be able to see more than one color and percentages with the pie chart. If you zip up your database and email it, I can take a look at it for you. Beth beth@integratedresourcemgmt.com