I was wondering if it is possible to make a sheet that would encompass projects, personnel and dates. Something like a Gannt chart but with one more element to it.

So the Y would be projects and X would be a combination of both dates and people who are assigned to certain parts. Gannt chart with bars being multicolored and each color representing a certain individual I guess would be the simplest way to do it.

Anyone have any ideas? Or how would i be able to pull this off.