I have created a spreadsheet in Excel 2007 for when I do time-studies of our manufacturing processes. All of our processes have multiple operations, some are manual and some are automatic. The goal is to have all the manual operations completed within the automatic machine cycle so that the machine runs continuously. If the manual operations take longer then the machine will sit idle for the difference in time. I have created a very manual Gantt chart at the bottom of my sheet that shows the operations with different colored lines. The length of the lines is determined by a ratio calculation between the operation time and the length of the longest line. This gives a visual representation as to how operations are done and if there is any overlap. I would like this chart to be complete automated but I don't know of a good way to show such data in a standard Excel chart. Any input would be appreciated

Cycle Analysis.jpg