I have a data table that consists of Students, their marks in various subjects and the respective year.
I would like to have a chart automatically generated based on info supplied in cells J2:N2 (ie Student ID, Year, Subject)
for example if i type 12 in cell J2 under Student ID and I input a specific subject like Maths in L2 I would like the chart to automatically show Student#12's Maths marks etc.
So it's similar to a Pivot Chart but instead of toggling the Pivot Chart Fields i just want to enter the aforementioned data in the aforementioned cells and have the chart update/display accordingly.
I do not know if this is even possible, so I am asking for guidance on this "problem".
Please see worksheet attached and screenshot below
Monster.PNG
Bookmarks