gantt chart

  1. M

    Gantt chart with conditional formatting, multiple cirteria and duplicate data. :) array, index, aggregate

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

    Gantt Chart & Formulas

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

    Gantt Chart 78 Hour Work Week

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

    Conditional Formatting: How to shade cells based on meeting 2 criteria NEED HELP ASAP

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

    Formula to flag a bar in Gantt Bar Chart

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

    Coverting hours in Gantt Chart Excel

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

    conditional formating across worksheets

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

    Creating Gantt Chart?

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

    Logic For a Gantt Chart

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

    Gantt Chart

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

    Gantt chart,workday function include weekend and somebug

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

    Highlight row when click a cell in that row

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

    Creating an Action List from a Gantt Chart

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

Some videos you may like

This Week's Hot Topics

Top