I have created a workbook to store data on student knowledge. I currently have a sheet where I can type in the students current level and there is a button/macro on the sheet that allows me to save a copy of the sheet with the date on it. Then later I can update the current sheet and save it. I have it set to show a pie chart for where the student currently is. I would like to have a way so that each time I create a copy of the sheet the information in the 4 cells is saved either on the original sheet or another sheet with the date of copy. I want to create a scatter plot with for series with date and a number as my axis. Here is a copy of what I currently have. Please help. Trying to help my students see their growth over the year!

Algebra 1 Student Growth.xlsm