Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sort Gantt - Help required
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sort Gantt - Help required
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accidental Sort | Excel Discussion (Misc queries) | |||
How to sort but keep linked formulas? | Excel Discussion (Misc queries) | |||
How do I format a column in alpha order? | New Users to Excel | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |