gantt chart

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

I am looking for the best way to use conditional formatting in a Gantt chart. I want the cells to turn blue if they fall between two dates. Any help would be greatly appreciated!

I have a Gantt chart in Excel for managing jobs that come in. Each row is a job with Job#, due date, content, etc. I manually arrange it so that job rows that have an approaching deadline next are on top, with jobs with the next nearest deadline below that, etc. Currently if a job ends, I...

HI Friends, i'm preparing a gantt chart for tracking the production days and percent of completion and days remaining. i have used conditional formatting to update by production date by black bar and days complete by blue bar. i also like to add the production complete to reflect in the column...

Hi All, Need some assistance with excel 2010. I have two columns (mentioned below), corresponding to that I need to highlight the weeks cells in the rows on that particular week column (as gantt chart) for which this effort is expected to last. <colgroup><col><col></colgroup><tbody> Start...

Hello, I have come close to what I need but need help on the last bit. I hope someone can please help me solve this. I need to produce a gantt chart for batch jobs that run multiple times a day and show that out for a week. So job1 will have multiple rows for each start and end time for each...

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 everyone, I need to make a gantt chart that display the amount of work hours corresponding to different part numbers. I want to the user to be able to input the Part Number and Hours and have the gantt chart display the amount of hours being spent on each part. After a total of 68 hours I...

I have a gantt chart that was built in excel. I need to shade cells in the timeline based on persons title under each project. I can provide a snip of what the layout looks like for a better visual. I want the PM's Green, Supers Yellow and Persons Reporting Orange. To get the green bar shown...

Does anyone know how to create a formula that will fill a shape with a specific color is a specific event happens? For my issue, I have created a Bar Chart to serve as a Gantt Chart to keep track of timeline events. Right now, each bar represents an event in time, and they end and begin one...

I'm looking to create a gantt chart for a project timeline. I need some help writing the code to handle. The goal is to take start date and have the code calculate and end date of the task my hours of the project. Also based of a percentage of my day. For example: If task A is going to take...

I am creating a gantt chart I have two sheets: Projects Schedules In Projects I have 2 columns Start Date Completion Date In Schedules I have the same projects mirrored but I have a column for each day of the month/year. I have put the corresponding date in each cell and formated white so no...

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

Right now I am working with a project management in Excel. On the left, I have a column for the name of the task, a column for the start date, a column for the end data, and a column for the status of the project (Completed, In progress, overdue, etc). To the right of all of these columns I...

I have created a gantt chart that has a list of employees on along with their start time and duration of their shift. I have conditionally formatted the cells to change color and add a unit value of '1' to the true cells(this would be the time of their shift. However, those that start at 9:00 PM...

Problem (in short) I had an excel gantt chart but when I use WORKDAYS function it doesnot include saturday and sunday how can i make them included Problem (Long) I've obtained a gantt chart (from http://www.youtube.com/watch?v=hxrX8qTSnOc) and I've modify very little thing inside ex. 1...

Hi Guys Basically I am running a gantt chart (critical path) in excel with dates across the top and tasks running down the left. When i click in a cell on the critical path, I would like the row and column to highlight or change colour in some way so that it is easiier to see what task I am...

Hi, I have a Gantt Chart that I use for showing me what actions occur on what date (example of which provided below). http://flic.kr/p/8pszXs I would like to create a macro to change this Gantt into an ordered action list, (example of which is shown below), I have tried to create this with...