Chart start time for overlap

**Mothman** · 10-03-2010, 07:44 PM

I am looking to do exactly what the linked post below has accomplished, but I would like the overlap to have a set "Start" time that I can change. This way the overlap will not always start at 6AM.

http://www.excelforum.com/excel-char...-in-chart.html

Please let me know if this is possible.

I am also attached the sheet used in the linked post for ease of access.

The working bar chart is the bottom one.

**MarvinP** · 10-03-2010, 07:56 PM

Have you tried to change the values in T2 and T3?

Is that what you are looking for?

**Mothman** · 10-04-2010, 09:20 AM

Originally Posted by MarvinP

Have you tried to change the values in T2 and T3?

Is that what you are looking for?

Hey Marvin,

Yea that only changes where the overlay ends. I'm trying to find a way to get the overlay to reference a range of cells with a "start" time. this way it wont always start at 6AM. Hope this helps explain