gantt chart

  1. N

    Dashboards

    Hi all Apologies if there were similar post, if so can you please link me to them. I have a single excel sheet downlaoded from a SharePoint list that gets updated daily. It has deadlines, multiple goal deadlines, multiple statuses, financial information. From this one datasource i want to...
  2. M

    Excel conditional formatting in a 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...
  3. O

    Half Day Conditional formatting

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

    Weekly Gantt Chart Conditional Formatting Formula

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

    Conditional formatting in a Gantt chart?

    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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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?
  12. 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:
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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 -...
  18. 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 -...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top