Forum Discussion
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
- Have a look at the INDIRECT worksheet function. If I understand your setup, it might look like this:
=AVERAGEIF(INDIRECT($H$31&"34"):INDIRECT($F$31&"34"),A12,INDIRECT($H$31&"40"):INDIRECT($F$31&"40"))
5 Replies
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
- 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- 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
