Gantt chart

[Aloysicus]

Is there a way to break a chart in between a duration to show another
information?

Eg, column 1 is the time start (08:30), column 2 is time end (17:30),
column 3 is duration (9:00) between column 1 and 2. However on column
4 is lunch break start time (12:00) and column 5 is lunch break end
time (13:00). Is there a way to show the lunch break on a gantt
chart?

Any help is appreciated.

Thanks in advance.
Aloys


--
Aloysicus

[Jon Peltier]

Aloys -

Here is an example worked out for you, plus a page full of links.

http://peltiertech.com/Excel/Charts/GanttChart.html
http://peltiertech.com/Excel/Charts/GanttLinks.html

It's come to my attention that Excel 2003 has a few obscure behaviors
which are different from older versions, so the procedure in the first
link above may not work as advertised. When I get a free moment, I will
work through it in all modern versions of Excel (i.e., 2000+) and
describe any inconsistencies in the procedure.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Aloysicus wrote:
> Is there a way to break a chart in between a duration to show another
> information?
>
> Eg, column 1 is the time start (08:30), column 2 is time end (17:30),
> column 3 is duration (9:00) between column 1 and 2. However on column
> 4 is lunch break start time (12:00) and column 5 is lunch break end
> time (13:00). Is there a way to show the lunch break on a gantt
> chart?
>
> Any help is appreciated.
>
> Thanks in advance.
> Aloys
>
>