Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

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


Re: Can I set marks in a gantt chart?

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


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


Re: Can I set marks in a gantt chart?

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


Re: Can I set marks in a gantt chart?

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.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.