The goal you want to achieve should be feasible, the key is that you are designing!

Is to do two worksheets:

1, original record registration form. Quantify the changes of each project every day, each stroke is a line, and doing a good job of registration means doing a good job of logging.

2, similar to your daily report above, as long as you enter the date in a cell, you can automatically display the effect on your chart, and you can display it every day by entering it casually. You can automatically extract data from the original record table for accounting and display the output!