resource chart plotted against time

[excelpostits]

if i have a table like the one below:
start end resource required
prj A 01/03/2016 14/03/2016 3
prjB 08/03/2016 24/03/2016 2


i want to have a table where y is resource and x is time and show the amount of resource required week by week. so my x-axis would be 01/03/2016, 08/03/2016, 15/03/2016, 22/03/2016, 29/03/2016, the resource required over this time period would be, 3, 5, 2, 2, 0.

How would i go about doing this?!?

Thanks,

[José Augusto]

Hi
Use a scater (plot XY)
See the file Scatter.xlsx

[Dineth]

extract week from your data, then pivot.