I have a project which is passed from one department to another and sometimes back again. The goal is to produce a graphical representation of this, similar to a gannt chart however it would need to be a single bar, with the X axis representing dates in a calendar year, and the Y axis representing the project (i.e. Project A). The bar needs to be stacked and colour coded so that the legend reflects the department to which the project was with at that given time. A department can be responsible for the project more than once so the ability to display this chronologically is imperative.
Thanks, much appreciated.