Dynamic Hourly Project Planner (Gantt Chart)

#HourlyGanttChart #ProjectManagement
Hello Friends,
In this video, you will learn how to create a dynamic hourly project planner chart. You can use this template to display your hourly task on the chart with very few changes. You can use it in your Project Management Dashboard. We have used conditional formatting on the chart to display the Pending, Completed and Work in Progress on the chart.
Download the practice files from below given link:
www.pk-anexcelexpert.com/dyna...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See 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:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

[@Rkeev1]

Your ingenuity continues to be a cut above; thanks for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@NeangBona]

PK, I like all your topic videos and files so much, thank you for sharing them. I can say all are very awesome.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nsanch0181]

Thank you PK I really enjoyed making that chart. It's a beautiful chart and you showed very useful techniques. Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@peternganga9371]

Beautiful and well presented, as usual.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@happylife1000]

Thank you so much for sharing this important information..very useful.. Keep us guiding like this..

[@shah6340]

Excellent Tutorial and well explained. Thank you so much.!

[@PKAnExcelExpert]

Most welcome🙏

[@mismar18]

Awesome Work, much appreciated

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@texculp67]

PK Very well done my friend!! I enjoyed the tutorial immensely!!! :-P Thanks for sharing!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@umitozay6566]

excellent job, thanks PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@KhalilAhmad74036]

Awesome Work, much appreciated, Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@yuwenchen3457]

PK, great work. How to add an additional beginning date & end date to the template?

[@safetymanagementsystem4903]

PK sir your videos are too nice and informative

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SyedMuzammilMahasanShahi]

Your presentation of work is becoming exceptionally good. Keep up tthe good work and thanks for the share.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rafakiyo]

great job!

[@PKAnExcelExpert]

Thanks

[@theoklingels3058]

Thank you very much.Can be used as example for daily workplanning.

[@PKAnExcelExpert]

Yes you can use it

[@charantyrekhanna7191]

Thanks for video's

[@PKAnExcelExpert]

Welcome

[@mandarsm1]

Thanks!

[@PKAnExcelExpert]

You are very welcome🙏

[@romlef526]

Beautiful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@torstenhollerbach]

Can I put this together within a team dashboard to grand a single view of every team member and show the open, todo and finished tasks?

[@srikanthchs7255]

Excellent.

[@PKAnExcelExpert]

Many thanks!

[@AbhishekMishra-cr1tz]

Very Nice video for learning thanks sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@josearmaza863]

Great, PK. Another excelent and instructive video. Please, could you check the download link, I could not download the file.

[@gilsoncosta6869]

PK, congratulations, excellent. Its possible to change hours per days?

[@souviksengupta2873]

Superb 👍👍👍

[@PKAnExcelExpert]

Thanks

[@danimordecai7611]

wow

[@PKAnExcelExpert]

Thanks🙏

[@hichamsabir1156]

hi PK Thank you for this great work and sharing can we related our plan to date and start time as like ms project thanks

[@R.nouneh]

beautiful and very clear explanation, can you please add video explain how to make employee day schedule with start, end, breaks and lunches chart. thank you

[@PKAnExcelExpert]

Will upload soon

[@abhinavmishra7786]

Really great sir one more think I am looking forward in your channel a similar project planner where wwe can switch view between hour, day, weeks and month. Is it possible?

[@ArmanKhan-iq3ji]

Thanks for video please make a video of sales dashboard on car's industry please.

[@egmedo1407]

I don't know what to say but thank you so much

[@PKAnExcelExpert]

Most welcome🙏

[@sreekanth7193]

Hi PK ji..
How can we create a chart for budget vs actual for Staff performance on monthly wise . Employee target per month will different based on their designation..is there any way to show in a dashboard..??

[@davidtuti1]

Congratulations for your video. I'm newbie with exel but you help me a lot. A simple question, is possible to modify minimal bounds of axis options to get that value dinamically. Imagine that I should change the hour of the start time. I shoud always to change the value . Thanks !

[@PKAnExcelExpert]

Yes you can!

[@563bhavesh]

Hello Sir, 1st upon your method for dynamic Gantt chart is really grate, it helps to plan project in detail where we can track every single loop holes.
I need your help to solve my queries related to my plan, where I'm using Start Dates & End Dates instead of Start Time & End Time. My graph is not showing Completed, Pending & WIP after selecting Start date while doing edit and than add during select data. I tried many times but failed to get it in shape. Can you pls. help me to understand what could be the issue ? dose this dynamic Gant chart method only works with numbers ? like time ? not like months 1 Jan 23 ? how to solve this. pls. share your email where I can drop my queries.

[@canonthescanner2642]

Hi. I am facing a Problem. right now, whenever i try to add a new Task, i copy one of the above tasks and just change the information. However, when i fill all the data (Start Time, end time , etc...) it does not appear on the chart, i don't know why. please help.

[@shereshin]

V nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@frndlygrl2000]

Hi can you create a data where you can automatic see the work schedule of an agent? Or recognized and match the schedule of their specific team lead.

[@PKAnExcelExpert]

will try to create a video on this topic

[@ianmcdonald257]

Fantastic gantt. Very useful. How do I increase the chart to include 24 hours?

[@PKAnExcelExpert]

Thanks. You can add the date with time and reset the horizontal Axis option to Auto

[@chikeziechekwas243]

Thank you PK. I noticed the Doughnut pie chart isn't dynamic.

[@sohilkhasatiya2984]

Hi Ok, can you make macro for multiple pdf file move in ppt

[@sajeerks1708]

You can make dynamically chart through convert table range.

[@MrDekinio]

Great video. How to add one or more bars in the same row? Thanks.

[@PKAnExcelExpert]

Add the data in the table to add more bars

[@shaileshsingh8906]

Hi PK , Can we make out chart dynamic by simply converting our data into table. Plz reply

[@ahmedsobea]

I wanna ask the same question

[@GaneshSutar-mf7bs]

How to dynamic the same with date change

[@iftikhardba]

How can we change time column to dates?

[@nagnihotri]

Hi Sir ,Please Pronounce your Full Name in your videos . You have already done a wonderful job by helping so Many people with your Knowledge.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@skrishna998]

@@PKAnExcelExpert HI sir i am folloewing the instructions as you said but i am not getting pending time when i apply the formula for the remaining completed & wip i am receiving the data i am noot understanding where did i go wrong....if i select pending for entire drop down list it is showing NA..how to solve this...

[@mmobrothers2861]

@@PKAnExcelExpert good job bro

[@mmobrothers2861]

@@PKAnExcelExpert great job bro

[@PKAnExcelExpert]

My name is Priyendra Kumar.

[@biancameeuwissen4542]

always long to see your skills

[@animzing4413]

Hi. Can you make an example like this using only conditional formatting. Thank you

[@PKAnExcelExpert]

Sure, will trust to create

[@tr8group61]

hello I don't speak much English well Can you give me an Excel to manage investments in cryptocurrency platforms to get a general overview of investments ... thanks for your help

[@karanpatil7887]

Dear sir ,pleases next time dashbord in Collection( Recovery) excel vba

[@Engr_Azam]

Dada, Can you make a project risk analysis in excel next time?

[@PKAnExcelExpert]

Sure,I will try to make such video

[@midhunkannan4801]

Amazing bro 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vilasnargund2835]

Can I Use this for my project? Please advise what precautions I need to take? Is there any template? Eagerly awaiting your reply.

[@PKAnExcelExpert]

You can download this template. Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@shenoudamedhat4892]

Can you make a massage reservation vba please

[@EmoHaramCore]

How to add and manage dependencies within tasks? This works great for me except for the missing dependencies

[@PKAnExcelExpert]

Will create another video with dependencies

[@rachelvanderkrift5718]

Sad that you dont explain why youb use a formula and what it does. The formula offset in define name doesnt work with me, and with this explanation i can not figure it out

[@wildherbs7693]

make
recepie costng please

[@GaneshSingh-lt8yv]

The time formula is not getting applied

[@PKAnExcelExpert]

Please download this template and then see the formula.
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@uniquesingh7604]

Hamko excel dashboard banwana hai

[@PKAnExcelExpert]

Hi,
I don't provide such type of services. You can download our free Excel templates from our website www.pkanexcelexpert.com and you can modify it as per your requirements.