gantt

I am designing a calendar for my department. I have dates set up incrementing by week along the top, with an event and start and end dates along the side. I have it set up to check if the start date is greater than the beginning of the week, and less than the beginning of the following week. If...

Hi - trying to formulate a Gantt chart to allow me to show where some of our employees will be on a daily basis. So far I have the formula: =IF(AND(G$8="Tues",G$9>=$D17,G$9<=$E17),"X","") This allows me to highlight where people are (in this example) every Tuesday - is there a way to highlight...

I have set up a gantt chart using excel formulas- with the start and end dates of activities, however I have been told that the activity only happens once every 2 weeks - can anyone help with the formula to edit what I have done so far.... =IF(AND(G$9>=$D18,G$9<=$E18),"X","") This is where I...

Hi, I used a 2D stacked chart to plot art as Gantt chart. However, what I need is a timeline plot. For example, in the sheet HERE, the 5 horizontal bars (Team 1 - Team 5) they all should be in one row and not 5 different rows. Any suggestions on how that could be achieved. The purpose is to...

Hi, I have a gantt chart that i have created in excel and would like to be able to reorder rows based on the work breakdown structure numbering. So, as an example, the gantt chart consists of 30 rows of data. The ordering for the rows needs to be determined by the numbering system in column A...

Hi I need some help. I have a gantt chart created in excel for a project, I also have a budget associated to each task in the gantt chart. The budget is monthly. Is it possible to link the gantt chart to the budget, and more specifically, if the timeframe for an activity changes (i.e. becomes...

Hi all, Just making a gantt chart for the first time and i'm running into issues. I've attached a screenshot of the chart and data, but for some reason the date at the time is going back to 31st March I've set the start day based on B2 and i'm not sure how to fix this issue. Does anyone...

Hi all, I have created a large Gantt chart in excel (through formulas, not as a chart). I have 2 additions I am trying to make to my sheet in order for it to be functional: Adding in a date line for today - a red, bold border line that lines up with today's date Adding in a shape (5-point...

Hello all! Almost all Gantt charts I see online are for kind of long term projects, as every column is a date. Is it possible to have an hourly Gantt chart for a working day (for instance, from 9 AM until 10 PM)? And also, can I have multiple tasks in one row? Let's say there's four team...

Hello, I've been tasked to customize the "Simple Gantt Chart Template" based in Excel to an Annual Template as oppose to the weekly one that's already in the Simple Gantt Chart Template. I need to adjust the following: 1.) I want the progress bar formatting to change from purple to the...

I am creating a Gantt chart and one of the last steps is getting a view of milestones on my Gantt. For this I would like to insert a shape whenever column C has a value, "Yes" and then place the shape on the row based on the date entered in column E. Here is what my sheet looks like so far...

Hello all, I'm working on a Gantt spreadsheet broken down by week to track our tax deadlines. Primarily I track: when the notice is received, the date it's due and the date it's submitted. The Gantt chart works great for this, however, I would like to set an additional conditional formatting...

I have projects in 1 worksheet which i have some ratings with delivery date. Also I have gantt chart in different worksheet excel created based on all projects. Question is how do I render the gantt chart to be updated based on changing the ratings of the project. Any help please? I have put...

Hi, I am doing a time and motion study on a 2 man process and I want to get a time line up and visually see when they are working together at the same time and when they are not and try to balance their work load so they continuously working and now waiting for each other I have a Gantt chart...

I’m looking for a way to easily see the task overlap per person in a gantt chart. How can I change the colors in the bar chart to match the color of the staff person assigned the task? Or is there a better way to do this? Thanks! Col A = Staff Sam - green Steve - yellow Jon - blue <tbody>...

Hello guys, I need your help to connect three tables and present the data as a gantt chart calendar. One table has ID numbers and columns with start and end dates listed. Second table has also ID numbers and names, but this table is used on a daily basis and it is changed every day adding and...

hi I have a gantt chart in excel and i have the following dates colored 06/11/2017 - 14/11/2017. The duration of the project is 9 weekday so I want the cells to color weekday. My start date and end date to the left is fine and excludes weekend (because I've put a weekday formula in) but I...

Hello I am trying to create a gantt chart in excel with stacked bar chart It works fine for tasks with duration greater than zero, but for tasks with zero duration, nothing appears on chart as it is stacked bar diagram so i try to draw milestone tasks with scatter chart seperately which works...

I am have a spreadsheet which i am trying to use like a gantt chart (long story why the company doesn't want to use project) Anyway, i am trying to make it so that when i add a week number to one cell it will automatically highlight and have information from another in the corresponding place...

I searched this forum and many others with the same results. I am unable, using the attached sheet, to place a vertical perpetual moving date vertical line. Many different tutorials explain ways to achieve this but I believe I am unable to replicate because of how my Gantt chart is designed...