Forum Discussion
What's the best way to graphically view resource utilisation in Project?
- Sep 11, 2022
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
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_27Sep 11, 2022Copper ContributorThanks 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-projectSep 11, 2022Silver Contributordc_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- dc_27Sep 13, 2022Copper ContributorJust on the resource graph again - is there anything i need to do / not do to get a graph for multiple resources?
When i select more than one, the graph is only shown for the initially selected resource