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.