Yes, you have read it right. I want to depict some data use in Stack Chart (of Bar Graphs in Excel) with Gantt Bars in Project Management. I want to track activities performed by resources at different times (please note it is not days). I want to have timeline (in hh:mm format under date similar to stock charts) on x-axis and bar graph for each resource (like stack chart) showing different colors for different activities. As time moves (on x-axis) we will know what that particular resource doing at selected time. A sample is tried but not lucky in attached excel sheet (it shows total duration of same tasks, but individual times have to be depicted). The excel file also gives requirements. I seek help from this elite group.

Thanks & regards,
MaheshActivity Chart Sample.xlsx