MS Project chart for multiple projects



  • I am a project manager and I use MS Project to manage multiple projects. I use a shared resource pool. I have been playing with the charts feature, in the resource file to try to get a chart showing a stacked bar chart (not 100%) showing project by person for a certain time frame.

    I have attached an image of the chart I do manually in excel right now. Any ideas how to get something similar in MS Project? This is the stacked bar chart I make manually in Excel



  • There are tools that exist that that can produce the kind of charts you are trying to create from MS Project. https://ssitools.com/ssi-time-scaled-values/

    You should know that using shared resource pools in MS Project can be very dangerous. https://answers.microsoft.com/en-us/msoffice/forum/all/using-a-master-project-with-resource-pool-the/27e9f63a-09d2-4dac-9e9c-17e5b4ec9b77 (MS Project expert and Microsoft MVP):

    WARNING: linked files are VERY susceptible to file corruption. If you ever rename, move, overwrite or save teh files on a WAN you roll the file corruption dice. It's a matter of when not if one or more files corrupt. If you do need to rename or move files first break the links to teh mater and resource pool, save all files, do what you need then re-link. Explore using unlinked master files that consolidate resource workloads for reporting purposes instead.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2