Forum Discussion

dc_27's avatar
dc_27
Copper Contributor
Sep 11, 2022
Solved

What's the best way to graphically view resource utilisation in Project?

Long time P6 user, looking for something similar to this in MSP...

 

 

A list of all my resources, against their utilisation in graphical (not tablature) form

 

I've tried Resource Graph, but that seems like you have to scroll around to see the resources - i cant select more than one resource to see cumulative

 

 

Any suggestions appreciated

David

  • dc_27 

    Yes you can see multiple resources on the Resource Graph. First you have to set up the Resource Graph Bar Styles to be active for "selected resources" as shown here.

     

    Then on either the Resource Sheet or Resource Usage, select a single or group of resources. In my sample file, it looks like this when two team resources are selected.

    But, just for reference, Project doesn't have a lot of flexibility for graphing resources. You can try the Resource Graph or one of the Reports but you may find it is best to export Project data to Excel and graph it there.

    John

  • John-project's avatar
    John-project
    Silver Contributor

    dc_27 

    Yes you can see multiple resources on the Resource Graph. First you have to set up the Resource Graph Bar Styles to be active for "selected resources" as shown here.

     

    Then on either the Resource Sheet or Resource Usage, select a single or group of resources. In my sample file, it looks like this when two team resources are selected.

    But, just for reference, Project doesn't have a lot of flexibility for graphing resources. You can try the Resource Graph or one of the Reports but you may find it is best to export Project data to Excel and graph it there.

    John

    • dc_27's avatar
      dc_27
      Copper Contributor
      Thanks again.

      And thanks for the note on exporting to Excel - suspect they would anticipate use of Power BI for more flexible reporting, or indeed Excel
      • John-project's avatar
        John-project
        Silver Contributor
        dc_27,
        You're welcome and thanks for the feedback.

        I'm a VBA guy so I use that for communicating between Project and Excel.
        John

Resources