Dynamic Project Planner (Gantt Chart) Part-2

#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:

Please download this excel dashboard from below given link:

Purchase our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

[shj]

thanks man need one for month and year thanks for your always helping me

[malikaouenza]

Thank you so much for this great video

[rameshkatta]

Hi Sir, It's very nice video. I am going replace project plan template with this template. Thank you very much for this video.

[josepcherto]

Thank you so much for the video.
What would you change in the code if we would like to create a working day list in row instead of all the days of the week? I think we would have to use but i dont know how to use it.
Thank you so much for your time,

[colleclement]

Thanks you very much for sharing, it is very usefull, I will check your channel more in detail. I have a question regarding the weekly periodicity, I try to have the week number instead started at 1. Grettings from France

[elenarobaldo]

Hi, thanks a lot for the video ! I tried to create the same macro but it does not work :-( I guess I'm doing something wrong! The gantt chart is not having the colored bars for the status. All the rest is working, but the macro seems correct. Do you have suggestion? thanks

[itschoo]

Is this chart downloadable? I tried creating it by following your steps but I get mixed up when it comes to the macro

[snehasinha]

I need a help.. e g . While preparing the project plan I have tow of the activities..one start on 25th May and end date is 25 th July ..but another activity start from 25th June and end in 25th August..in such case how to follow ur Gantt chart

[npsainisingh]

I have added two more column now daily and weekly drop down not working to calculate the week numbers
i value change from 7 to 9 but week calculation is i/7
Please guide

[Daniel-tlex]

You're my hero :-) Super! I love your videos! Question to this Gantt : Daily and weekly is great but it is possible to extend this gantt with month and quarter?

[abdelmalek]

HI BROTHER CAN I USE IT IT SEEMS LOCKED OR SOMETHING

[vickyfn]

Hi tried doing the Dynamic Project Planner part 2. But I dont know how to write Macros. I need this urgently. What is the possibility

[LarsIngeHolen]

Can you show us month and year too? Nice video 👍

[MrKumarsujit]

I would like for in the column on the right to take a cell on the left and add all previous cells to it. So that it looks like the two columns below:

A1 | B1
0 | 0

1 | 1

2 | 3

3 | 6

4 | 10 same cell

[ambujnirala]

Sir when we insert the column then it will not work in weekly so request you to please let me know how i can fix them

[sanjaydeshmukh]

Sir, Is it possible Gantt chart in hour?

[rollysharma]

Not really helpful.. Given formula did not work. Sad to see the same format not working for me :-(