I wanted to create a line chart (or column chart) that would be "high" for an active duration and "low" for inactive time duration. For example if I have a table of start and ending times in hours and minutes (time of the day) say for instance times when someone is doing a task. at the end of the day I would have a chart that which would be easy to read the duration of work and not work.
I have excel 2007
H