Creating a Gantt in Excel - Basic

I want to post a quick video on creating a Gantt Chart in Excel. As an example, professionals , managers or project controls may not have access to a scheduling software. However, their could be a need to create an executive Level 1 or Level 2 schedule. This method allows for the Gantt to be somewhat dynamic for purposes of updating.
Advanced Planning Analytics
www.advancedpl...
Project Analytics iPhone App
appsto.re/us/t...
Project Analytics Android App
play.google.co...
Follow Cesar:
Instagram: / cesar.ramos2019
Twitter: / advancedcpm
LinkedIn: / cesar-ramos-91186818
Facebook: / p6professional

[@AlqGo]

Wow that cumulative percentage line is such a nice complement!

[@advancedplanninganalytics6047]

It was a last minute add but does seem to complement

[@realloreal]

this is truly brilliant, I can't fathom all this. I really need the basics to start....

[@NavneetDwivediELearninghub]

Lori Favela kzbin.info/www/bejne/Zl6uf5WLgbinhMk Check this...it might b helpful too...

[@JIMMYASH433]

Navneet Dwivedi c

[@nessyb9822]

Cheers for the video content! Sorry for chiming in, I would love your opinion. Have you heard about - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a great one of a kind guide for getting 7000 plus project management and business templates minus the normal expense. Ive heard some super things about it and my old buddy Taylor got astronomical success with it.

[@naufalhadi8684]

From the activities, looks like you're a process engineer, also me too. And this is what I looking for since I have develop my engineering schedule

[@jenniferfigueroa9621]

Thanks so much. This was very helpful and super easy to follow.

[@saulsanchez7805]

Appreciate video content! Forgive me for the intrusion, I would appreciate your opinion. Have you considered - Weydaniel Organized Dominator (erm, check it on google should be there)? It is a great one off product for getting 7000 plus project management and business templates minus the headache. Ive heard some super things about it and my work buddy finally got amazing success with it.

[@coolfix948]

Thanks , I prepared it in one go !

[@tanawatpokaratsiri5323]

Clever Excel Tutorial. Thanks

[@SirKks1]

Hey Carlos, no doubt you know that critical path tasks cannot overlap

[@fisenknan3981]

Excellent video. Learned a lot from you, TQ

[@DongskiTeeVi]

Thank you very much! Very big help! :D

[@kwakuppong]

thanks so much. you made my work so easy

[@sunnyabdullah6790]

Great....Very helpfull for projects tracking

[@kimberlywilliams1166]

Thank you, very helpful.

[@peace5003]

Thanks for making it simple

[@brandonnaupa1696]

ohh this was really good for my personal planning

[@construccionesaccion4909]

thanks a lot, was very helpful for me at this moment,

[@samuelmechano7659]

Thank you so much. This is very helpful

[@rkpujar450]

Fantastic ! Thumps Up bro.

[@elshadisam]

YOU HELPED! THANKS!

[@TheHRMaster12]

Most Excellent

[@necipizarro7996]

this is so helpful..ty so much

[@prakashexe]

Great work

[@lazaruschiyaba9590]

This is real good

[@Popart-xh2fd]

Very nice tutorial. I'm trying to align the vertical text to the Left but I don't see how, is there a way? Thanks.

[@DeathBanana08]

Do you know how I'd be able to change the color of one of the bars halfway, so that one color represents it was one way for some time and another way for later time?

[@buroze]

nice very informative

[@safaulzaman2966]

Good

[@rogermatildo780]

thanks for sharing..this is absolutely a great stuff...can we add as well the actual status on this?

[@advancedplanninganalytics6047]

Yes. It takes another couple of steps but I'll post another video showing how to make progress bars work.

[@advancedplanninganalytics6047]

This is the progress bars kzbin.info/www/bejne/hIe1oZJobbGEna8

[@joannaestrabillo2551]

hey so im on that part where im about to change it to line chart and my 2016 excel seem to have a different kind of line chart. please help me!!

[@Julia00777able]

this is great! thanks a lot! However, when tried to change the graph type for the "% Cum" series didn't work for me, it turned just one line (followed all the steps) - any clue why that might be? Thank you!

[@MrX3room]

Thanksss

[@BINGUS712]

Hey there! Nice video. Is there a way to include predecessors for a task?

[@advancedplanninganalytics6047]

Hypothetically, you can show it but this is only Excel so it doesn't show dependencies in the chart unless you purposely show it

[@nidhichawda]

how can we add milestones if we need to.

[@advancedplanninganalytics6047]

Nidhi, there is a way but the way to make the chart is a bit more confusing and with more steps involved. If there is enough interest I'll post a video on how to make that happen.

[@nidhichawda]

That would be great. thank you!

[@advancedplanninganalytics6047]

www.advancedplanninganalytics.com/excel-gantt-using-vba.html

[@pohchins]

Advanced Planning Analytics ś

[@randallrosa7313]

can this be replicated with Excel Online?

[@advancedplanninganalytics6047]

Honestly, I haven't tried it yet

[@nooni3420]

Hi when i execute the secondary data it shows the line but it completely hides the rest of the primary data. Using excel 2016. Can you help me please.

[@advancedplanninganalytics6047]

You need to be sure the primary & secondary are different chart types

[@ridvanaktas2990]

Hi, I tried but it did not work for me either. I am using Excel 2013

[@NavneetDwivediELearninghub]

kzbin.info/www/bejne/Zl6uf5WLgbinhMk kzbin.info/www/bejne/apu6onl-aq2tmpY Check this...it might b helpful too...

[@ricoasi859]

there are activities that are happening simultaneously, wont it affect the projection of the s-curve? You just added the values and plotted it in sequence. Should we add the values with the same time just like what he did on his video(kzbin.info/www/bejne/pJLdonmlZbSkjMk)? IM JUST CONFUSED. THANKS

[@romulotagalo5965]

hi pane