gantt chart

  1. H

    Gantt Chart - Markers

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

    Need a quick assistance for a Gantt Chart in Excel

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

    Automate Chart

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

    Returning a value in a column offset from its criteria

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

    week/year (wwyy) format

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

    Gantt Chart Deadlines

    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?
  7. 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:
  8. A

    Coloring Cells depending on Hourly Schedule Table

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

    Conditional format based on the week

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

    Gantt Chart - Dependencies

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

    My conditional formatting code does not work

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

    Gantt Chart Formulas

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

    Reversed Gantt Chart Formulas

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

    Next Level Gantt Chart - Trying to Copy Certain Data

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

    Gantt Chart Troubles

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

    Creating a Gantt Chart for projecting lead time in manufacturing.

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

    Only Show Dates between a defined start date and End Date

    HI there, Can someone help, i have a problem where i have the 4 columns consisting of an Estimated Start Date (C19) and End date(D19) and Actual Start Date(F19) and End date(G19) for different project functions. I am sorted for the the start of point here i have in Cell J16 =DAY(F19+1) which i...
  18. S

    Gantt Chart Help

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

    Annual PM Gantt Chart by week and conditional formatting

    Hello, I am new to this board as of this morning and here hopefully with your help to save my life :-). I am stuck at work trying to create a detailed work plan for the entire year for my project. I have used conditional formatting before for small gantt charts, but now need to create an...
  20. K

    Automatic rolling dates in an embedded chart

    I am looking to create a Gantt Chart with date/duration data. The setup is that each column header is a milestone, each row is a different project, and the data in between are a mix of dates and durations in order to build the Gantt Chart. I have embedded this chart in SharePoint but was hoping...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top