gantt chart

HI there, Can someone help, i have a problem where i have the 4 columns consisting of an Estimated Start Date (C19) and End date(D19) and Actual Start Date(F19) and End date(G19) for different project functions. I am sorted for the the start of point here i have in Cell J16 =DAY(F19+1) which i...

I have a gantt chart that I like and understand how to update the information. What I am looking for is how to roll up all the sub task conditional formatting to the mask task line. Example Gantt: <tbody> Start End Main Task Y Y - - - Y Y Y - - - Y Y Y SubTask 1...

Hello, I am new to this board as of this morning and here hopefully with your help to save my life :-). I am stuck at work trying to create a detailed work plan for the entire year for my project. I have used conditional formatting before for small gantt charts, but now need to create an...

I am looking to create a Gantt Chart with date/duration data. The setup is that each column header is a milestone, each row is a different project, and the data in between are a mix of dates and durations in order to build the Gantt Chart. I have embedded this chart in SharePoint but was hoping...

Hi All, I need to create a Gantt chart that shows how long it is taking to approve construction drawings. I have attached a schedule of the drawings in question with each one having its own reference number and a issue and review date for each revision. I need the Gantt chart to show the time...

I'm learning how to use excel for real life project Scheduling. My work is giving me practice promblems and I'm basically on my own learning excel. I learn by baby steps. my job field is operations management I'm use to doing heuristic by hand and I'm an old dog learning how to use excell and...

I'm trying to find a formula that will help me to auto-calculate the Start Date, Due Date, and % Complete based on an existing formula for Work Breakdown Structure (WBS) in a Gantt Chart. I have a project plan/gantt chart that has three levels of detail in the WBS (1, 1.1, 1.1.1, etc.). Here's...

I have a timeline the teams previously cut and paste color code phases of the project (planning, build, requirements, develop, etc.). I developed a workbook with a formula page that the timeline now works off start and stop dates of the phases. I have a formula page of =if(and identifying each...

I am making a horizontal bar chart, showing projects under different categories over a 10 year time span. I was able to organize the data the way I need it, but am having issues with making the chart autopopulate. The chart data is being pulled from 'Sheet 3', which is a sheet that is...

Hi All, I have a table of data and I'm trying to create a gantt chart, I have looked on numerous websites, even posted on here and I still can't get it to work, can anyone walk me through the process start to finish please? Many thanks Harvey

Hi All, Can anyone help me build a Gantt Chart from scratch? I have attempted previous posts to adapt mine, but I personally believe it will be easier to start from scratch? Does someone perhaps have a project timeline Gantt chart template? Many thanks Harvey

Hi All, (Just before you read away I do have a version of the graph which contains no sensitive data, which can be sent) I have created a Gantt Chart which illustrates some project dates and when they are planned to be finished by, the chart also shows their scheduled publish date. Regarding...

Hi I'm creating a Gantt Chart in Excel that shows time elapsed between start times and end times. I want to have my y-axis to have units of 30 seconds, so I've got the major axis units set to 0.0003472222222222 (equal to 1/24/120). This works fine if my graph doesn't span more than two hours...

Hi There. Does anyone know how to enter in multiple start dates and durations in a simple gantt chart for excel? I came across an office support for Project, but unfortunately I am using excel. I have a task that begins on March 5 and ends on March 10 but I want to restart it March 15 (as an...

I was writing a quick gantt chart spreadsheet using conditional format which has been completed. (you probably know how it was done... just by simple T/F value and changing font and cell colour by conditional format in excel) i just want to add one additional feature, best without VBA...

Hi everyone <tbody> I have created a Gantt chart, but the years on the axis have duplicated, year 2000 is listed twice. I am not too sure how to attach the chart here????:eeek::eeek::eeek::eeek: Could somebody have a look at this for me? Many thanks...

Row B=Status (In Progress, On Hold, or Completed) Row C= Task Description Row D= Start Date Row E= Estimated Completion Date Row F= Actual Completion Date Cell I5=Date (Part of a series of dates within the calendar month) Current Formula...

Hi, So, I'm creating a gantt chart in google spreadsheets and need to have bars fill in specific colors based on the start date, estimated completion date, todays date, and the tasks progress. In other words, I need the time between the start date and estimated completion date to be gray. As...

Hi, I have a table of data that has Code, Title, Start Date, End Date Does anyone know how I can turn that data into a gantt-chart style xls? Many thanks Peter

Hi All, I am dealing with a document similar to a very large Gantt chart with Dates at the top of each column and non zero values in the grid below recording which projects are worked on. I am looking for a formula that can read the corresponding date to the first and last entry within each...