gannt

  1. E

    Appended Row Data (Gantt Style)

    Hello All, I am building a file that allows someone to create a basic timeline using dropdown selections. These dropdowns in individual rows change the durations of their respective tasks. I would like to build a visual timeline bar that appends all of the rows data together into a single...
  2. CubeMonkey

    Possible Conditional Formatting use, to pull text from one cell to another.

    🤓 Good day my fellow nerds, I need help so I came here to see what Master Nerd could be so kind to solve this issue I am having. What I am trying to do: Using Conditional Formatting, I would like the = function to pull text from one cell to another based on a Start Date. Example: Text in...
  3. S

    Indirect within sumproduct

    I have the following formula but want to use INDIRECT function on the column name within the table GANNT so becomes easier to update =IF(F$7<$C$2,0,SUMPRODUCT(--(GANTT[WK40_2]=$B$11))*E$8) Have tried the following but get a #REF...
  4. 8

    Problem with a graph

    I have a Membership tracker in excel where member can log in and excel logs their names (Column A), Daily Fee (Column B), Time in & Time out (Column C&D), and then totals for Hourly Total, & Fees Owed. I want to create some kind of to illustrate when people are coming and going. I am having a...
  5. C

    Gannt Chart Query

    Morning all I have created a GANNT Chart using Excel , it will consists of a number of milestones, using the dates in column D to plot them it will form part of a more detailed Dashboard. I am using conditioning formatting to generate where the milestone is displayed The powers that be would...
  6. A

    24/7 rolling 7 day a week schedule gannt

    =AND(F$2>=$C3,G$2<=$D3) This is the formula I have in my conditional formatting for a gantt 24/*7 schedule. <colgroup><col><col><col span="2"></colgroup><tbody> Angela Sanchez 5:00 14:00 Maria Grosso 7:00 16:00 </tbody> I have column A employee name, column c start time, column d stop...

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