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.

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.