I have create a sheet that records student data and understanding. It is designed to show the student's current understanding on different levels: none, basic, proficient, and advanced. Each is represented with a number. I would like to track the changes that I make in each level and record them over time. I can currently create a pie chart of the current information, but I would like to record this over time to create a line graph to better show the students growth.

Here is my current workbook. Thanks for any help

TECH 1 Student Growth.xlsm