Workload graph/chart

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!

August 31st, 2015 10:08am

I would make a Gantt chart using cell formulas and CF, with a formula that looks at the start and end times, and a set time per columns, along the lines of 

=IF($B2*1440<=(COLUMN(A1)-1)*15,IF($C2*1440>(COLUMN(A1)-1)*15,"Y","N"),"N")

copied to the right and down, formatted custom with ;;; to hide text and use CF for a fill color when the cell = "Y" - in this example, each column is 15 minutes.

Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 2:59pm

Excel 2010 with free PowerPivot Add-In.
Compatible with Office 2013 Pro Plus.
With real Gantt chart.
http://www.mediafire.com/view/0xajt4fq96coo74/06_11_15.xlsm
Easier way: Use MS Project.

August 31st, 2015 3:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics