Organize your data so that across the top row you have dates and times and
down the first column you have employee names. Then, in the resulting grid
put a 1 for whatever time period the employee has a task. Create a Bar chart
from the data.
You may want to use an add-in like the one below to help you with your task:
Gantt (Project) chart
http://www.tushar-mehta.com/excel/so...art/index.html
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu
"Mutiple grouped Gantt charts in Excel" wrote:
Hello everyone,
Problem.
A company has 3 employees and workdays are Mon to Fri.
Working hours are from 9:00 to 21:00
Each employee has assigned task for all days with start time and end time.
Objective.
To haev a Ganntt like chart that will show for the whole week and for each
day and for each employee the time interval for which they have tasks asigned.
I have tried a lot of suggested solutions but could not arrive at the one am
looking for.
Grateful if anyone could help me there as I consider myself as a middle
level excel user, and find it difficult to use VB inside excel.
Thnx in advance.