MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can I set marks in a gantt chart?


Posted by espen on January 22, 2001 12:33 PM

I have a ganttchart that shows when employees work. Can I set marks at given places, for example at 8:30 to 9:40, and 11:15 to 12:20?

I would be thankful if someone had any inputs and suggestions

espen


Posted by IzzyDude on January 22, 2001 12:40 PM


What do u mean by marks?
Give more details...

Posted by espen on January 22, 2001 1:22 PM


sorry here are some more details:

Ex

An employee works from 08:00 to 16:00, and I want to put some colors to some of the hours where this emplyee has got work at special fields. One field marked from 09:15 to 10:00 and another from 12:00 tom 13:30.

espen

Posted by Tim Francis-Wright on January 22, 2001 2:21 PM

Check out
http://www.geocities.com/SiliconValley/Hills/6814/Examples/ChartGantt.xls
for some techniques to highlight certain activities
in a Gantt chart. The first example (the easiest)
might be what you want--you could set up 5 ranges
with the special times in ranges 2 and 4, with
some spreadsheet magic to separate a worker's
day into the appropriate ranges.

Hope this helps.