Hi,

I have a simple sheet containing employee names with
Vacation start and end dates for each employee. To the
right I have columns representing months. How can I
generate a Gantt chart showing each employees vacation
start and end date as a bar from the data inVacation
start and end dates?

thanks
Sri

Hi C.Srikumar,

Take a look at Jon Peltiers site for information.
(http://www.geocities.com/jonpeltier/...ngColumns.html)

And a very useful set of links to all this Gantt.
(http://www.geocities.com/jonpeltier/...anttLinks.html)

C.Srikumar wrote:
Hi,

I have a simple sheet containing employee names with
Vacation start and end dates for each employee. To the
right I have columns representing months. How can I
generate a Gantt chart showing each employees vacation
start and end date as a bar from the data inVacation
start and end dates?

thanks
Sri

--

Cheers
Andy

http://www.andypope.info

Hi,

I have recently completed an Excel Attendance / Holiday Chart which will
cover any specified 12 month period.
Should you wish to see a copy, drop me a line.

regards,
Don
--

"C.Srikumar" wrote in message
...
Hi,

I have a simple sheet containing employee names with
Vacation start and end dates for each employee. To the
right I have columns representing months. How can I
generate a Gantt chart showing each employees vacation
start and end date as a bar from the data inVacation
start and end dates?

thanks
Sri