How to make resource graph for a whole group?

Home Forums Microsoft Project Discussion Forum How to make resource graph for a whole group?

Viewing 3 reply threads
  • Author
    • #483107

      I like the built in resource graph. But, I would like to be able to make a graph showing the workload for the entire team. Is there a way to make the same graphs for the entire resource group, instead of just individuals?

    • #483976

      I don’t think this is possible. I tend to take the data out of MS Project and into Excel to do this sort of analysis as a Pivot table grouped by month and resource group will quickly give me what I need. It seems to be an oversight by MS as this is something that I have been trying to do for ages and I can’t be the only one who would like to be able to review across a group 🙂
      You can of course have a split-screen with the graph at the bottom and the people at the top and select those who are part of a group and then be able to scroll through the group which could give a quick view but it isn’t quite what you’re after I suspect 🙂

    • #483982

      For sure it is possible, although awkward. I have done this by copying the resource usage information into Excel (like Miles) then manipulating it with some formulas and graphs. As far as I know I could not do this in MS Project by itself.

      -Bob C.

    • #492470
      jeff Heath

      Yes, you can generate the reports using Power BI.

Viewing 3 reply threads
  • You must be logged in to reply to this topic.