Resource allocation chart

[Jaymond Flurrie]

I have this kind of tables (of ranges)

1) Projects

ID Project Start End
1 ProjectA 1.1.2012 1.2.2012
2 ProjectB 1.1.2012 1.3.2012
3 ProjectC 15.2.2012 31.3.2012


2) Resources

ID Name
1 Max
2 Pete
3 Jack

3) Assignments
Project Resource
1 1
1 2
2 2
2 3
3 1
3 3


And now I would need a "broken bar"-chart out of those. In the chart, I would need as Y-axel resources (Max, Pete and Jack) and as the X-axel time (here, from start of January 2012 to the end of March 2012).

What's the smartest way to put this chart together?

 

[Steve=True]

Hi Jaymond,

I would recommend the following setup as a Stacked Bar Chart.

I did reverse the Vertical axis.

I also had to fix the Horizontal Axis (x) min and max to 40909 and 40999 and changed the number format of this axis to Short Date. You may have to fiddle with the Max number to make it larger than 40999 and then move it down to 40999 in small bits until you get 3/31/2012 as MS Excel keeps trying to give you something smaller than that as the max X axis date.

I also have changed the Fill value to No Fill for the Filler bars.

Please let me know if this helps!

Steve=True