gantt

I thought I had a good idea, but I am not so sure now. I am trying to use the same concept for in-cell charts using the REPT() to make a Gantt chart. The problem I am running into is that I can't get a bar to cross cell boundaries without some white space, so it looks clunky. I have used...

Hi First post, so please excuse if added items/references wrong. I am trying to develop a Gantt using VBA, I cannot use the Conditional Fromatting style or any style that prevents me from referencing the date cells which have colour or text. I would like to have two sheets. Sheet 1 = Gantt and...

Hi All, I was hoping someone can help me with a Gantt chart I've made. I want the dates at the top to be from the dates the project is starting to finishing. However, they don't match my start date columns and then when I plot the remaining duration date it doesn't correlate to the project...

https://www.ablebits.com/office-addins-blog/2014/05/23/make-gantt-chart-excel/ I've found this resource to be every helpful for daily GANTT charts. What modifications do I need so I can look at one day by hours when my start and end times are hh:mm? Not really looking for one that shows...

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...

<tbody> A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ BK BL BM BN BO BP 1...

Hi guys, I have some issues creating a gantt chart (stacked bar). There's plenty of information about Gantt charts in general but not on these topics: - repeating different daily tasks - tasks that span midnight So I'm stuck with the following: -Creating horiz. axis from 18h to 18h (instead...

OK, after browsing the web for a few days, I can’t figure out how to create this specific Gantt sleep chart. It has with 6 daily repeated tasks (in this case sleep sessions), with data spread past midnight, from 18h00 until 06h00. The closest online instruction I found, was this one, but it...

Hi, I have found this excellent way of creating a gantt chart using conditional formatting here on the site. I have made som small changes as I would like to base my gantt chart on week numbers instead of years as used in the example. The week numbers are based on a dates using the WEEKNUM...

I would like a formula that could generate the following outputs <tbody> AB AC AD AE AF AG AH AI AJ AK AL AM AN AO ex:1 2/1/14 2/8/14 2/15/14 2/22/14 3/1/14 3/8/14 3/15/14 3/22/14 3/29/14 4/1/14 4/8/14 ex:2 2/1/16 2/8/16 2/15/16 2/22/16 2/29/16 3/1/16 3/8/16 3/15/16 3/22/16 3/29/16...

Hi There, I am trying to make a horizontally stacked bar chart to track some progress. I would like to have a percentage value on the x axis, but have it repeat itself once it reaches 100 (to track between 0% and 100% for each task). The vertical axis will contain the main tasks. The series...

I am trying to make a large spread sheet that will automatically fill in the 1's under the number if it appears between the start-stop columns; as shown in the example. It will have many start stop columns filed in, for hundreds of numbers. I can get it to work for the number if it is...

I think I may have bit off more than I can chew. I said that I could do this and don't think I can now after playing with it for 3 days. I need to create a chart (assuming Gantt would be best) to auto shade a certain number of cells. We have complicated calculations to give the minutes needed to...

I have set up a Gantt formula by the day. I have also set a conditional format that highlights todays date in the spreadsheet. My issue is that it only highlights the actual date, I want it to highlight the whole column. Any suggestions? I have a feeling I am not describing this well so please...

Good Afternoon All I currently have a Gantt chart within an excel report that I have managed to get working based upon my limited knowledge and searching threads on this forum. Although it works ok there are elements that I would like to work a little better. The layout of the gantt data is...

Hi there,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm attempting to chart data obtained from our phone system to see when users are logged in/on rest. <o:p></o:p> <o:p></o:p> I’m using Excel 2007.<o:p></o:p> <o:p></o:p> The data we...

I have data that I need to format (a la a Gantt chart). The data is: -Project Name -Project Health (3=red, 2=yellow, 1=green) -Durations of project My formula to code the Duration of the project works and is this: =AND(P$3>=$J4, O$3<=$M4). However, I want to amend this formula so I can...

Hi I'm trying to create an Excel Gantt template that has week commencing across the horizontal axis (ie 2/1/12, 9/1/12) On the vertical axis based on each task I have the start date and end date (as actual dates (is 4/1/12 SD 10/1/12 ED) What I would like is for Excel to automatically...

Hi, I'm new here! please be patient with my problem! I would say I have a basic grasp of excel and have been working with it for several years. Using excel 97 on XP. I am creating a formula, in effect to return a result in a Gantt chart, which references times and returns "1" or "0" if true...

Hi, I've created a Gantt chart using an Excel bar chart and would like to be able to conditionally format it if possible. The cells in the "Duration" column are conditionally formatted Red, Black or Green depending on whether they are Evenings, Nights or Mornings "Shifts". What I would like...