gantt chart

I was trying to provide conditional formatting in my Gantt Chart. However, I have difficulty developing a formula that will trigger to highlight the cell or range, as the date is not a usual one. I'm hoping that someone from this group can help me solve the issue. I manually provided the colors...

Hi All, I am trying to make a Gantt chart with a twist! I wish to split each day into AM and PM sessions. However I am looking for a formula that will work with conditional formatting, such that if the time is between 00:00-11:59 the cell is highlighted, and when the time is between 12:00-23:59...

Hi I'm trying to create a conditional formula that will colour my gantt chart based on the progress percentage. My formula =AND((G$6+6)>=start,G$6<=((end-start)*progress)+start) seems to fall apart in some instances and I can't figure it out for the life of me. At 0% progress week 1 should be...

Hi all, I'm trying to make a fancy automated Gantt chart type thing for my team to use for keeping track of our projects without having to fill in the cells by hand. I have it mostly covered, however my main last snag is that I want to be able to do some manual formatting on the cells that will...

Hi everyone. I've made a Gantt chart that requires markers on each bar for a mean. I have manually placed markers there, but does anyone know if there is a way to include a marker in the data itself? Every time I update the data, the chart changes and the markers don't as they are just pictures...

Hello, After I enter a date range (start date and end date) for a certain task, I want to be able to physically enter each day a value; say 0 for not done and it would show it in red color, and 1 for done and it would show it green color. Also when I put either values 1 or 0, I want the data...

Hello, I am trying to use data that is displayed in this chart in columns R to V. However I want to only include rows that have a value displayed in my data for my Gantt chart. I am trying to figure out how to insert the correct data in vba and was wondering if I could get some help because this...

Hello I need help summing data in a column if the range of columns falls on a certain day. See below for an example of my Gantt spreadsheet. It is divided into 8 hour days. The jobs are on the left side "Y" axis and their progress is depicted in each row. To the right of the job are the...

Hi everyone, I am looking for create a gantt chart to track different stages of projects, I tried rearranging a template I found that had the week already in the template (the only one i could find). Each stage has a start and end date, and the date has to be entered in the wwyy format. The...

My gantt chart shows a list of tasks and their start date, end date, duration etc., but within the calendar/timeline I would like it to show a marker on the date of the deadline. How can I do this?

I am trying to conditionally format my gantt chart and have used the formula: =AND(F$6>=$B9,G$6<=$C9). It does work, however it then highlights the entirety of the end column of my table. Is there a reason for this/how do I get rid? Any help will be very much appreciated!! :biggrin:

Hi All, I am new to making macros with color conditions and I have been having trouble figuring out the logic to my code. I have a table with various rows of jobs with their start and end time on a given day and each of these jobs can pass through multiple machines which are also included in...

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

Hi Everyone, We are trying to recreate MS Projects functionality in XLS and running into a few issues (weak in VBA). We've created Gantt Chart which has multiple dependencies (tasks cant begin unless previous task finishes or task must complete if other task finishes). To add additional...

Hello! I am doing a multiple project Gantt chart that looks like this:  The sheet gets its data from another sheet named "DATA" as shown below: What I want to happen in the ACTUAL PART is when the date for the specific step is equal to the plan, the color of the cell will be GREEN and RED if...

Hi everyone, I am currently creating an employee scheduler using a Reversed Gantt Chart, one where the user plots the schedule in the chart then the START and END details are automatically updated (using formulas) while plotting. I used legends such as 0 - vacant hours, 1 - working hours, 2 -...

Hi everyone, I am currently creating an employee scheduler using a Reversed Gantt Chart, one where the user plots the schedule in the chart then the START and END details are automatically updated (using formulas) while plotting. I used legends such as 0 - vacant hours, 1 - working hours, 2 -...

I have a spreadsheet with four sheets: 'Full Project', '1', '2', '3'. On each is a Gantt Chart with activity table, the full project sheet has the data for the full project, sheets 1-3 contain the same data for only selected periods of time (each third of the project timescale effectively). The...

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

I am needing to create a gantt chart for calculating lead times for building products in my manufacturing business. I am not very advanced in Excel and would really like some help with this subject. I need to be able to set how many products I can manufacture in a day, (such as 30) and then...