don't know how to transpose this

You are already recording the progress daily using a script function. To make the function copy data into a blank column instead of overwriting previously recorded data, replace .insertColumnAfter(7) with .insertColumnAfter(6). To run the script once a day, use an installable trigger.

To transpose the data into a new sheet, Insert > Sheet and put this formula in cell G1 of the new sheet:

=query( transpose(Sheet1!F1:K), "where Col1 is not null offset 1", 0 )

...where F is one column before the first column with recorded data and K is the current last column with recorded data. The formula will automatically adjust and expand its range as new columns are inserted daily.

Then Insert > Chart on the new sheet.

don't know how to transpose this

You are already recording the progress daily using a script function. To make the function copy data into a blank column instead of overwriting previously recorded data, replace .insertColumnAfter(7) with .insertColumnAfter(6). To run the script once a day, use an installable trigger.

To transpose the data into a new sheet, Insert > Sheet and put this formula in cell G1 of the new sheet:

=query( transpose(Sheet1!F1:K), "where Col1 is not null offset 1", 0 )

...where F is one column before the first column with recorded data and K is the current last column with recorded data. The formula will automatically adjust and expand its range as new columns are inserted daily.

Then Insert > Chart whose data range points to the transposed data on the new sheet. You can place the chart in the project data sheet if you want.