Excel Tutorial: Make interactive visual schedule (Gantt chart) with one formula!

Make an interactive horizontal bar visual schedule in just a few minutes. All using 1 formula and 1 conditional format!

[MD-cutt]

Thank you after 7 years. Never late to say thank you happy holiday

[RealSaladsamurai]

Awesome tutorial! I was looking for something quick and that gets the job done without a lot of overhead. This does the job!

Also- I wanted to do this without merging cells so that I could copy the start/end dates in from another existing sheet that is more of a "list view" of the project. If you want to get around merging cells, I have the following tweaks that get the job done (not perfectly, but it gives the rows enough separation for my tastes):

1. When you add the conditional formatting, choose a black font as you did, but then instead of a solid black fill,
2. Choose "Fill Effects" and use the "Horizontal Gradient"
3. Select the first "Variant" that has white out toward the top and bottom of the pattern.
4. Change Color 2 = black. Hit OK twice to apply.
5. Then in all of the cells that have zeros and ones, make the font size = 1 and make sure the "Alignment" is centered both horizontally and vertically.

That's it! Then you don't have to add all those blank lines and can avoid a lot if the hassles that come along with merged cells.

[joethompson]

Thanks Dr. Soy for a very easy and useful tutorial. I'm now using your template to make a Gantt chart to manage a biological restoration project.

[MisaelBautista]

The person in eBay told you useless, let me tell you what you are: You are a Life saver.

[Waayeel]

it is very comprehensive but a little bit harry, some times i can't understand what you click but no problem. thank you so much

[karitoyama]

Thank you so much for this video, it's the best example I've seen so far. Question for you - I'd like to add a condition to the formula to highlight the end/due dates separate from the duration. I think the right answer is to set it to another value, 2, for example. Is there an easy way to add that condition into the formula?

[mskikok]

Hi, this video is great but still a bit to advanced for me, being someone who is not familiar with Excel at all. Do you have one a bit more basic and not as fast the teaches how to create a gantt chart? Thanks

[tammyeerdmann]

This is an excellent webinar and it I was able to get this work without any problems. I would like to know how to expand this so it will span several months instead of just one. Can you provide me some guidance on how to achieve this?

[deporcs]

Great video! With 0, 5 x speed it was easier to understand for me :) thx

[hiteshprajapati]

what are formulas for feb, march, april and other months

[areebakomal]

if i want same for feb what formula should i use?

[dylanwilliams]

Very useful, thank you. Any reason you don't use Column A? (What purpose does it serve?)

[shijucherian]

Thanks, this video tutorial is very easy to follow. I was wondering if instead of daily tracking can we do it week wise and in that case, what will be the formula to apply.Regards

[larrygreen]

A nice and clever approach. I'm looking to create a moving timeline. I'm thinking it would be a combo chart (line & bar) and the line would naturally adjust based on the TODAY() function in relation to a milestone date. Ever done that?

[joelpiazza]

Thank you for the incredibly useful video! I've read the comments below and have seen your response regarding excluding weekends from being included (filled with black) in the working days. I am calculating my "end date" from the "start date" using the "workday" function. I do not understand how to include your weekend exclusion function (, ,, not(left(text(E$7, "ddd"), 1)="S") ) into the rest of the function. Could you respond with what your complete E3 function looks like with the weekend exclusion function included? Much appreciated and thank you!

[johnvineyard]

I'm looking for a sheet very similar to this but will stack along the same row for capacity planning

[wasimsheikh]

I have seen this Video, It really helps, Currently i am planning for 1 project in which i need to exclude saturday and sunday, Can u please help through if formula as shown in this Video

[yukiko]

THANKSTHANKS. IT REALLY HELPS ME IN MY PROJECT.:) BUT STILL IM NOT YET DONE, HOW CAN I MAKE THE COLORED BLACK DATES(BOX) AS A BUTTON AS I CLICK, A FORM WILL POP-UP.

ACTUALLY I'M MAKING A RESERVATION FORM. I WANT TO CLICK THE FOLLOWING DATES RESERVED AND AS I CLICK A FORM WILL POP-UP THEN I WILL FILL-UP THEN THE FOLLOWING INFORMATION WILL BE PUT IN A MASTER SHEET.

AND LAST HOW CAN I PUT DIFFERENT SHEETS INFO INTO FINAL SHEETS, WHERE IN DIFFERENT SHEETS I PUT DIFFERENT INFO BUT SOME ARE THE SAME. I WANT THAT THE SAME INFO WILL NOT BE CHANGED BUT ONLY CHECKED AND THE FOLLOWING DIFFERENT INFO WILL BE WRITTEN OR WILL BE UPDATED INTO THE FINAL SHEETS. SO THAT ALL THE INFORMATION IN DIFFERENT SHEETS WILL BE ARRANGED AND DUPLICATION WILL BE CHECKED.

soorrryyy for my grammar. I hope you can help me. thanksthanks.

[tjellin]

This is very helpful. Thanks for the tutorial

[meredithchurch]

This was very helpful, used it to make a chart of time availability for interviews (so times vs. dates). I was wondering, though, if there is a way to show one person's availability if it is split during the day. For example Jennifer can meet from 9-12 and 3-5 and 6-7... can you have all of this information on one line, or do you have to have three separate lines for those time slots per person? Not sure if that is clear...