Time and Date Charting

I'm collecting data to prove out a lighting control package. The lights are regulated by available daylight and occupancy within the space. I have a data logger that records on and off cycles.

I need to prepare a chart to display lighting time of use on a daily basis. I was thinking of a horizontal stacked bar chart with Time on the X axis and Date on the Y axis. Each bar would represent a 24 hour day, with on and off represented by different colors.

Something like this:

Mon 2/09 ==ooo==oo=oooo=oo==oooooo=o====ooooo==o

Tue 2/10 ===ooooo==oo=ooooo=ooooo==oo=======o==

________2400 0100 0200 0300 0400 0500 0600 0700

I have tried several different methods, but the fact that some periods split days screws it up. Any thoughts?

Can you post your chart in a workbook despite that some periods split days?