Does anybody know which would be the most appropriate chart/graph to display work tasks over period of time?

Lets say I have a spread sheet with 4 columns (1.task number; 2.start time; 3. End time; 4. Duration in sec)

I would like to display data similar to Gantt chart. On Y axis - task No., ON X axis - time and the horizontal line would show which task has to be done at what time. But the same task can be repeated later on.

Thank you!

• Moved by Edward ZMicrosoft contingent staff 9 minutes ago not excel developer

Hi GyTasS,

Since this forum is discussing about Excel developing, and your issue seems more related with the product feature of Excel, I will move this thread to the more related forum.

Reference: http://social.technet.microsoft.com/Forums/en-US/home?forum=excel

Thanks for your understanding.