Gantt charts on Excel Spreadsheet

  • Thread starter Thread starter C.Srikumar
  • Start date Start date
C

C.Srikumar

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/Excel/Charts/FloatingColumns.html)

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

C.Srikumar said:
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
Click to expand...

--

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
 
Back
Top