Filtering Data and changing data range from graph? (Excel 2007)

[auroralily]

Hi,

I have a lot of data on students in 2 sheets. One called GraphData:

The other called TargetData:

I have a graph that plots a line with no markers for the cells H2:U2 from TargetData and plots another line for the same cells in GraphData. The formatting of the line for the GraphData series is set up so points in a PC column are invisible:

I would like to add code to the graph so a user can do the following straight from the graph:

• Click the select group button to filter the data based on the contents of Row B in GraphData
• Upon selecting the data the chart will show the Flight Plan (from TargetData) and test grades (from GraphData) keeping the formatting as set above and the title is selected from TargetData (eg TargetData!$A$2)
• When the button 'Next Student' is clicked the chart changes the data series and title to the next row in the filtered data (eg changes from TargetData!$H$2:$U$2 to TargetData!$H$3:$U$3)
• If the student is the last one in the data set clicking 'Next student' show a message 'You have reached the last student in the list - plotting data for student 1' and the when ok on that message is clicked the chart shows the data for the first student in the list.
• When the button 'Previous Student' is clicked the chart changes the data series and title to the previous row in the filtered data (eg changes from TargetData!$H$3:$U$3 to TargetData!$H$2:$U$2)
• If the student is the first one in the data set clicking 'Previous student' show a message 'This is the first student in the list - plotting data for last student in list' and the when ok on that message is clicked the chart shows the data for the last student in the list.

I would also like to use the other buttons to apply additional filters:

• Only one filter (in addition to the group filter) can be applied
• When pressing button 'Filter X' (eg Filter PPI) is adds an additional filter to the data set depending on the relevent row (eg 'N' in Row F for 'Filter PPI')
• Once I have the base code for one button I can apply it to the other filter buttons myself - just need the starting point.

Possible extra feature but no idea if it is possible:

• When a button (not included on pic) is pressed all charts for that data set (eg all students in 11l1) are exported to one word document

I've tried searching forums but couldn't figure out where to start. Apologies for the long question - hopefully it is sufficient in describing what I would like to do but I'm happy to clarify if not

Thanks