Dynamic Project Planner (Gantt Chart) Part-1

#GanttChart #ProjectPlanner #VBA
Hello Friends,
In this video you will learn how to create a dynamic Project Planner (Gantt Chart) with the daily and weekly view. View is change while select is changed. Here we have used 3 type of status Completed, Pending and In-Progress.
Dynamic Project Planner (Gantt Chart) Part-2:
• Dynamic Project Planne...
Please download this excel dashboard from below given link:
www.pk-anexcelexpert.com/dyna...
Purchase our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkan-excel-expert-9748...
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert

[@enevesj]

Thank you very much for the tips, or should I say for the valuable lesson.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ModernPindawale]

Thank you sir for your first part of Gantt chart

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@fikremariammekonnen3479]

Hi there!
I would like to thank you. This is very important, but I need to make it in weekly base. for instance, week 1, Sep, 2019. Can you help me to make this?
thanks!

[@michaelb.7727]

hello, can you please help? did you delete the formula in cell H3 at that moment or why did it disappear and no longer appear? 10:31 Thanks!

[@1988Ssk]

I have a querry regarding Gantt Chart. How can i display time taken by a specific task ( if its achieved within the planned time it should show 1 color & if it exceeds the planned time it should flag in red color.) is there any specific formula for showing this..? Also can i co relate the % of task completion with above task.

[@1988Ssk]

Sir Planned v/s actual kaise map kar sakte hai ek hi gantt Chart Me

[@youarebest2]

Can you help me with the hourly based gant chart we have tasks for 8 hrs 4 hrs

[@PKAnExcelExpert]

I will try to create such video

[@makarandkapare3484]

How to select all columns?

[@fredrickkuiper2988]

Can this be used for genealogy where the beginning and end times are birth and death years?

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.

[@vijaypawar4778]

Just a one quick question ? Need to add few milestones also along with Activity and shape of Milestone should be diamond shape and colour should change depending on the status

[@PKAnExcelExpert]

I will try to add this in next version

[@NSM1985]

The formula is not working even though we follow each and every step the indirect function not reflecting the formula

[@ramaxow]

Why don't you tell us when you get the status (complete, pendingp) please.

[@qarampage8056]

You can check mine too

[@aniketandeo7651]

Sir aap indian ho ke english kiyu bolate ho ye bat mujhe achi nahi lagi