How to have a graph/chart represent whether or not a cell h as been filled

is this the sort of thing you mean

Yes! That is exactly what I was looking for.

Do you mind explaining how you accomplished that so that in the future I can do something similar on my own?

Edit: Although, while this creates the exact type of graph that I was looking for, would there be a way to accomplish the same thing without use of the "E" column?

I ask because it would be much easier for workers to input information correctly if they didn't have to remember to put 1's next to every filled time slot and 0's next to every empty time slot.

Edit edit: On my way to a solution using the "ISTEXT(cell)" command...

Final edit:

Figured it out, thanks for your help etaf.

I paired "ISTEXT(cell)" to the activity column and used the resulting data to create a chart with the time slots from column A. Now, all I have to do is find a way to change the axis so that the intervals 0, .2, .4, . . . , 1.2 are shortened to only 0, 1. But, I'm sure this is something I can figure out on my own.

Thanks again!

sorry, i thought i replied on how it was done, anyway you seem to have worked it out

to reduce to 1 hour axis - then you could just setup a graph helper column
but if 1/2 hour had no activity how would you want to display in the hours, as it can only be on/off