Forum Discussion
Trying to create a scheduling graph
Hello, I am trying to create a scheduling graph. So, the schedule is made on one sheet, and that sheet is titled Schedule. On a separate sheet I have my graph. Let's say that boxes G5 and below ...
I expanded upon the work by m_tarler in the attached workbook, first showing how conditional formatting and Data Bars work for partial hours at the end of a workday, but not at the start. I also show an alternative that graphs partial hours whether at the start of the workday, the end of the workday, or both.
You did not mention which version of Excel you are using, or on which platform. The formulas in the attached workbook require Excel 365 or later (or possibly Excel for the web).