Thanks - I'm going to definitely try this!!

"Del Cotter" wrote:

On Wed, 4 Jun 2008, in microsoft.public.excel.charting,
said:
I guess my message was too wordy.
Anyhow, I've looked at the StepChart timeline and the StackedBar -
with different widths. I need a combination, I think, but I have no
idea how to go about programming it.

I would use an XY (Scatter) Chart with x error bars. The details are
more awkward to explain than to show, so here's an example:

http://www.branta.demon.co.uk/excel/timeline.xls

Condition your data like this:

fromTime Unit OK miss<60 miss60 starttick
05/01/2008 12:30 0001 0:15:01
05/01/2008 12:44 0001 0:00:13
05/01/2008 12:45 0001 5:04:40
05/01/2008 17:49 0001 0:10:21 0:00:00
05/01/2008 18:00 0001 0:10:19
05/01/2008 18:10 0001 0:18:41 0:00:00
05/01/2008 18:29 0001 0:00:42
05/01/2008 18:29 0001 0:00:18
05/01/2008 18:30 0001 7:00:16
05/01/2008 00:00 0002 11:03:57
05/01/2008 11:03 0002 0:00:16
05/01/2008 11:04 0002 0:10:27
05/01/2008 11:14 0002 0:00:33

Get rid of your toTime because it's not of interest if all the durations
are in the OK and miss columns.

Give your units actual numbers, and use them as the y value. Make three
series that all use the same two columns as x and y.

Now give them three sets of x right error bars, one each. Green for OK,
orange for small miss, and red for long miss.

Use the "starttick" dummy zero as a x left error bar, so your long
misses have bars at both ends.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.