Hiya,

I am creating a Gantt chart in Excel to show the tasks in an aircraft
turnaround:

The timeline is from 18:00 when the aircraft stops at the terminal gate to
20:30 when the plane pushes back from the gate (and heads to the runway).

All of the tasks in the Gantt chart are the various processes involved on
the turnaround, for example cleaning, security check, fuelling, etc.

So far this is very doable using techniques offered by Jon Peltier and many
other sources.

However, there are two things I'd like to add that I just can't get my head
around:

1. I'd like to capture some items that have no duration, such as push back
time/ pilot arrival time. I assume I am using the right method by pasting
another series in, but I just can't get it to work. I'd like these to be
stars rather than bars. Any ideas?

2. This is the ambitious bit! What I am trying to use this for is to compare
the timelines of the actual process compared to what is planned for. For this
I would like to have such a Gantt chart with two bars/stars for each task -
one bar for the planned (coloured in gray), and overlapping this I would like
a blue bar with the achieved timescales.

Can anyone help me on this - it would really be useful as an ongoing tool (I
have set something up so that the user can select whether they want to see
the performance on a particular day, an average over any timeperiod they
specify, etc). Also, I would like to be able to add this within an Access
database - anyone know if Access can handle it (assuming Excel can in the
first place!).

Thanks everyone,

Basil