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 Friday, August 28, 2015 7:20 AM not excel developer

Hi,

According to your description, my understand is that you want to create a chart Gantt chart. Am I right? If yes, we can present your data in a Gantt chart in Excel. Please see this KB:

https://support.office.com/en-us/article/Present-your-data-in-a-Gantt-chart-in-Excel-f8910ab4-ceda-4521-8207-f0fb34d9e2b6

More detailed steps:

https://www.smartsheet.com/blog/how-create-gantt-chart-excel-video

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

If I misunderstood something, please feel free let know and share us a sample.

Regards,

George Zhao
TechNet Community Support