I wish to create an XL sheet that will be used weekly to update new data .. and output will be graphs imported into ppt.

The requirement is for each week of the year for each individual record number of Hrs effort on a particular task.

So there are
# Individual name (currently ~30)
# wk number (1-52)
# Hrs value (from 0.5 to 40)
# Task name (currently ~40)


Any one individual may be assigned to any task .... each task could have one or more individuals assigned.
Although they would be unlikely to be assigned to more than ~5


My initial thoughts were Individual names in a column on left ... running left to right a column for each week number ... I could use drop down list to set list data entries of the task names ... all that is within my current Excel knowledge.
What I can't figure out is the way to add the last part .. the Hrs value.

i.e each entry needs individual name + task name + wk number + Hrs

There will be lots of names or tasks that have no entries for particular weeks .. so flexibility required.

Welcome advice of best way to structure this, as once set up needs to be handed over to admin function for monthly update.