Report generation using drop down menu help

[trager551]

I am using an excel, mulit-page database to keep track of student academic and manipulative skill progress during our fire academy. I would like to be able insert a page that contains a drop down menu of the student names. When a name is selected, it would generate a 3 charts.
the 1st chart would show the student and how their attendance compares with the rest of the class.
the 2nd chart would compare the selected student with the rest of the class academically
the 3rd chart would compare the selected student with the rest of the class related to their manipulative skills.

since i am new to excel, any help would be appreciated.

[Palmetto]

To use a drop down to select a student name requires the use of Data Validation with the list option.
See this link on how to use Data Validation

As for the charts, there are two options:
Pivot Chart Report or dynamic charts
See this link for help on dynamic and interactive charts

Pivot tables are a bit more involved and take a little more time to master.
See this link to get started if you choose this option: Using Pivot Tables & Pivot charts

Index of charting help

Before you begin with charts, you need to first develop the reporting metrics that will become the series data for the charts.

Post a sample workbook with representative (but non-sensitive, dummy) data after you have gotten off to a basic start and someone will help.

[trager551]

Post a sample workbook with representative (but non-sensitive, dummy) data after you have gotten off to a basic start and someone will help.

Here is a sample of the data sheet with an included data validation drop down list on sheet 5.

[ChemistB]

Do you just want a simple bar graph showing average of student versus average of class? Or do you want a line graph with each quiz (for example) with two lines (average and student)?

[trager551]

Do you just want a simple bar graph showing average of student versus average of class? Or do you want a line graph with each quiz (for example) with two lines (average and student)?

just a simple bar graph showing the comparison between student and the class....both with quiz grades as well as attendance

[ChemistB]

I had to modify some of your formulas to remove zeros and errors. For example, in Quizzes!AK2

Please Login or Register  to view this content.

Otherwise, you wouldn't be able to get an average easily. I added a % Attendance in Column BM of Attendance. You might want to modify that one similarly to the one above so that if attendance is 0, it's not included in the average. For your charts, I used INDEX and MATCH to find your dropdown name in the appropriate spreadsheets. The charts automatically update when you change the name. Is this what you are looking for?