I am creating a chart in Excel with details of which projects / tasks that a resource is working on. e.g. from now til the end of the year the training dept has 3 trainers working on project A, 2 on project b and 1 on project C, but project C finishes at the end of October. This is a master project plan with approx. 50 smaller tasks linked to it.
I have taken over the start and finish dates to Excel, but this will only show me totals. I need to break it down to show for October we have 6 trainers working on 3 project, November and December should show 5 trainers on 2 projects.
I can't find a column for Month?
The Task Usage report was helpful, but I can't seem to add the project names to this - nor can I send this to Excel.
If you know how to get the monthly breakdown into Excel, or know how to send the task usage report to Excel I would appreciate your help.