Creating Charts from search results.
Please somebody explain how I can create a chart from the results of a search of a database. All I want to do is find out how male and female students faired in recent exams. I have carried out two searches one for feamle results and the other for male results. They are clearly displayed. From here on it all goes wrong. All I want is a chart showing the proportion of boys who got different grades and on a separate chart the proportion of girls who got different grades.
Try this file:
Barring any mistakes it should let you select the gender, sort the results, and show them on a chart of Names and Score.
If you want to show them in groups rather that individual scores then calculate what group their score is in as part of their individual record.