gantt

Hi Ladies and Gents, I plan to use the critical path method (CPM) technique to manage a project I will begin working on soon. I therefore set up an Excel sheet with the following columns: Column A: Activity Code (different activities represented by different letters) B: Description of Activity...

Hi Ladies and Gents, I plan to use the critical path method (CPM) technique to manage a project I will begin working on soon. I therefore set up an Excel sheet with the following columns: Column A: Activity Code (different activities represented by different letters) B: Description of Activity...

Hi, My first post here, and hopefully a) it makes sense, and b) someone can help! Scenario: I have some data in excel, containing various jobs. Each job has a start time and an end time (separate columns): I have created a gantt style chart on a new tab that currently auto populates...

I have made a gantt chart using conditional formatting, with the "AND" formula. I wanting to make a different color for different criteria. Example(s): 1. A Gantt style worksheet with 3 colors, 1 for each shift: A1 Red Shift, A2 White Shift, A3 Blue Shift. 2. A Gantt style worksheet with 3...

Hi guys, A relatively straight-forward question here, but pretty sure it requires some coding (not my strong point!). I have a range as per the below example (apologies for image quality) which extends across the whole calendar year 2011. Where you can see the Bitmap references, I wish to...

We are drawing monthly gantt charts using excel, where for each activity users colour fill cells across a row in the corresponding monthly titled columns. I would like to export this data into another program, and need the start and end dates for each of these activities. Is there a formula or...

Has anybody here tried to insert a Project document (basically a Gantt chart) onto a worksheet? I'm working with Excel and Project 2007. I'm getting very annoyed because every time I exit from editing the embedded Project document, the preview image of the Project document object becomes...

Hello Everyone, I have a question and that I don't know if excel 2003 can do. I have a need to make a Gantt chart. The problem is I can make it, it's just I only have 5 tasks. Say they are numbered 1-5. Well these tasks are repeated but not at the same time but at different time frames...

Any help or guidance would be amazing on this one: I'm wanting to use Excel as a project management tool. I have designed individual project sheets, with a cel per day. Each sheet is a 6 month snapshot of the project, and depending on the project there might be just one sheet (6 months) or 4...