Charts

Hi, 

I am trying to create a chart to show my groups workload. Please see attached file for how the worksheet looks. It is basically a gantt-table-ish with 20-30 projects (one project per row), each column represents a week and all the activities are categorized in colors with conditional formatting based on how they are clustered. I would like to know if i can make a graph of this to see the workload per week?

Thx :)