I need to create a GRan Chart in excel, which will automatically update based on info typed in a table.
In the image you can see the table
* The chart must have 1 row for each T.A. captured in table.
* Every ticket is represented in chart by a square, and ticket number must be inserted in the center of square
* The order of the tickets is based on the Dep column, which mean the ticket that must en before the current ticket starts.
* T.E. is the estimated time in minutes (block of 10 minutes) that is the time each ticket takes to complete.
*The number of columns each ticket will fills depend on how long the T.E. is.
Basically is like a project plan but in excel