Del - Thanks this did the trick! Thank you so much.
--
Karen W.


"Del Cotter" wrote:

On Sat, 8 Dec 2007, in microsoft.public.excel.charting,
KAREN_W said:

Is there any way to show an overlap with a / symbol on the overlapping day
for a particular bus?

I don't know what you mean by "with a / symbol". You can show an overlap
with another colour of bar (maybe a darker version of the same colour,
to imply double service). The calculations have be a little more
complicated in order to do this.

Start1 Single1 Off Overlap Single2
L180 09/01/07 5 9 0 6
L220 09/15/07 4 6 0 4

In this scheme, "Start1" and "Off" are invisible bars, "Single1" and
"Single2" are light colours, and "Overlap" is a dark colour. The
formulae look like this:

Bus Start1 Single1 Off Overlap Single2
=B3 =C3 =MIN(E3,F3)-C3 =MAX(0,F3-E3) =MAX(0,E3-F3)
=H3-MAX(F3,E3)
=B4 =C4 =MIN(E4,F4)-C4 =MAX(0,F4-E4) =MAX(0,E4-F4)
=H4-MAX(F4,E4)

An example may help:

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

I've included a spinner control that changes the duration of the first
bus on route L180. See what happens when you click on it so that the gap
shrinks to zero and then the buses overlap? The Off column becomes zero
and stays that way, and the Overlap column switches from zero to a
positive number of days. Meanwhile, the Single1 bar stops growing and
the Single2 bar starts shrinking.

This system breaks if Single1 completely overruns Single2, so if you
have to account for that happening, you'll need to construct a scheme
even more complicated, or abandon the idea for some other method like
Pivot tables.

--
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.