Forum Discussion
Gnatt chart based on a time schedule
I need to create a chart based on a list of courses and their scheduled time. I am having trouble starting this. Right now we manually color in the course blocks based on the course times each day. H...
ChristinaN9 I didn't use the chart but instead used some formulas to fill in the chart with the time if a class exists at that time and blank otherwise. Then I use 2 conditional formatting rules: one to color all cells with time values in them and the other to make the text of all cells with time above and below match the fill color so you get the effect of your image.
See attached.
BTW, although not required, I did make the course listing sheet a table and used table references and named the range of times in column A "times" to make it easier/cleaner.