Getting "Max Units" into an Excel Chart

Hi Marie

Thank you for your question and for bearing with us. If you could forward your file I'll see if I can help. Please forward it to info@stl-training.co.uk for the attention of Andrew

Kind regards,
Andrew

Hi Marie

Thank you for sending through the email. The closest I can find in MS Project is to set up the Resource Usage view to suit your requirements.

For example you may wish to right click on the time-phased part to the right and from the context menu that appears choose detail styles.

From the available fields list you might choose to show Peak Units and hide everything else then click OK.

If you would rather show peak units as decimals rather than percentages go to Tools > Options > Schedule and set Show Assignment Units as Decimal

Highlight all your resources and click the Show / Hide Assignments button +- to fold up the details below each resource.

Now you can select all the resource side (Try clicking on the blank square above the row number 1)

From Edit choose Copy, Switch to Excel and in Cell A1 paste the data.

The next bit is a little fiddly. We need to repeat the process with the Time-Phased data. Click on the word Details and all the right side of the sheet should highlight. From Edit choose Copy then carefully paste beside the data already in the sheet.

Whilst not ideal I believe that other than using VBA programming this is the only way to get time phased data into Excel from Project 2007.

Let me know if this gets you closer to the print out you are looking for.

Kind regards,
Andrew