I can created an S curve in excel using planned / actual based on man hours and timescale from Project (task usage, BL hours and Actual hr fields )and put into excel. I am trying to find a way to use the remaining hours (after changing the status date and Updating Project) but there is no field for that in Task usage. I want to be able to transfer them to excel so that the remaining hours are showing in the timescale used for the S curve and then I can add a forecast line to my graph.
Probably very simple to Super users but I am struggling.
Regards peter