Very nice choice for charting performance of one versus many.
If I understand you correctly, you want to highlight the chart based on selection of a student. If so, do not use a quick filter, for that will remove all but the selected student; and you want to be able to see how that student is faring compared to the others in the class(es).
In the attached workbook I created another worksheet that simply contains the student names. I added that workbook and the Duplicate data workbook you had to a dashboard. Creating a Highlight Action within the dashboard allows me to select a student and have that student highlighted within the chart.
Hope this helps,
SubjectGrades - AP.twbx.zip 62.3 KB
Nice solution Andy.
Many thanks for your simple and elegant solution.
Is there a way to display only the subjects that the highlighted student took? The actual datasource that I am working with has over 30 subject lines with each student taking six subjects out of the 30. It will therefore be helpful to include only those subjects that relate to the student to help the teacher focus by reducing visual clutter.