I have a master file with several sub-projects and resources assigned to them. Is there a way to make a bar chart in Project Pro report that shows the work hours for resources based on the sub-projects they're working on (outline level:level 2)?

I just simply can't get the chart to show Level 2 outline as a parameter result.

enter image description here

Attached is a mock-up chart.

Thank you kindly for your assistance and have a great weekend

  • Are you using Project 2013 or Project 2010?
    – JulieS
    Jan 16, 2015 at 15:11
  • I'm using Project Pro 2010. I'll try to create the chart per your instructions, thank you Julie!
    – Millie T
    Jan 16, 2015 at 16:13
  • Great. Let us know how you get on.
    – JulieS
    Jan 16, 2015 at 17:55
  • It worked! thank you so much, you saved me :D
    – Millie T
    Jan 19, 2015 at 23:32
  • You're welcome, Millie T and thank you for the feedback.
    – JulieS
    Jan 20, 2015 at 20:40

1 Answer 1


With some tweaking you can get the chart from the Baseline Work Visual report. Open the master project you created using the pool and create the Baseline Work visual report.

Once the data is in Excel make the following changes:

  1. Turn off the display of Actual Work and Baseline Work in the Pivot table field list.
  2. Turn on Resources in the Pivot table field list. They should be added to Row.
  3. Drag the Tasks from Rows to Columns.
  4. Turn off the Weekly Calendar

Your chart should now look like: enter image description here

I hope this helps.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.