gantt

  1. E

    Conditional Formatting for Gantt Chart not working

    I am trying to create a gantt chart in excel using conditional formatting. For some reason, my formulas don't work for every event. I have two colors: dashed gray for uncompleted tasks, and red for completed tasks. The formula for the uncompleted tasks is: <style type="text/css">p.p1 {margin...
  2. B

    Help! Gantt Chart Conditional Formatting

    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:
  3. D

    Excel Gantt: Slow Performance

    Hello Mr. Excel Team Members, I have an issue with a Gantt Chart Template that I create, something it makes it extremely slow... I'm not sure if its due the formulas, conditional formatting or other stuff... Could you please take a look of it and support me to speed it up? Thanks a lot...
  4. J

    One line Gantt Charts

    Gantt charts typical display a different task or job on different lines. So one project will have five lines if it has five different phases. It it possible to create a Gantt chart with all phases on one line? I want to be able to look at different projects and see how their timelines match up...
  5. K

    Condition formatting for overnight hours worked

    I'm trying to create a chart using conditional formatting that will show the hours that each employee is working. I have a formula for that works for Chris' time but can't figure out a formula that covers both Chris & Richard's schedule since Richard is working overnight. Richard's hours...
  6. C

    VBA for merging and centering cells and including text based on a dynamic range and text reference

    Hello all, I am creating a dynamic Gantt chart for an upcoming workshop in which several team members will view and collaboratively edit the start and end dates of various work streams to align on a work plan. I have a worksheet with tasks in column B, the task's respective start date in...
  7. H

    Return month from GANTT table

    I have a Gantt Table based on activities (vertical axis) and and month (horizontal axis). In this Gantt table, cells are colored if there is activity in the month I need a formula to show me in which months that business is doing. For example, if an activity takes place in month 1, the...
  8. G

    Help with ghosted grid lines- need to remove them

    I received an excel gantt chart to work with. It displays item #, task name, start date and end date. At the end is a gantt chart showing horizontal bar graphs. It had horizontal ghosted grid lines visible. Vertical grid lines were not visible. I began populating the sheet and decided to...
  9. C

    Gantt Chart help please! Formula to calculate date range based on budgeting criteria

    I am trying to find a formula for a Gantt chart that will calculate and fill in the graph dates based on a budget dollar amount entered. If the budget dollar amount is $100, and each week is "worth" $2, I need the formula to calculate how many weeks the $100 would cover and fill in the bar...
  10. B

    3 Axis chart with gantt

    Is it possible to create a chart like this in Excel? I was thinking making a bunch of individual charts and overlaying them with transparency and resizing them so they match up might work. But if there is a better way I would appreciate some assistance please. You see it is based on date across...
  11. D

    Determining work days and date ranges (Gantt related)

    I'm working on a gantt chart where I want to be able to determine the number of "work days" which occur as of a certain date (which could be a weekend or holiday start). I have to subtract non working days such as holidays, which are listed in another tab. The function I am using is WORKDAY()...
  12. H

    Creating a Gantt Chart in Excel using conditional formatting

    To Whom itConcerns, I’m trying to create a Gantt chart which would look something like this: https://www.youtube.com/watch?v=00s5efQWrgU&t=41s However I’ve designed mine around projects rather than tasks, and each projecthas a start, forecast completion and actual completion date. The...
  13. A

    Highlighting Cells Between Dates

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

    Bi weekly formula...

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

    Gantt question

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

    plotting timeline

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

    Work breakdown structure sorting....

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

    Linking a gantt schedule to a budget

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

    Gantt chart issue

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

    Adding shapes to denote milestones based on cell reference?

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

Some videos you may like

This Week's Hot Topics

Top