Dynamic Hourly Project Planner (Gantt Chart)

[@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

[@shah6340]

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

[@PKAnExcelExpert]

Most welcome🙏

[@Rkeev1]

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

[@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

[@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

[@lennawalker788]

@@PKAnExcelExpert Hi! Can you link me to the video showing GANTT with breaks in tasks or jumping between tasks? Specifically, I am trying to make a chart to track my time at work, with multiple tasks. I have to jump between different patients -- for example, my 8:00 AM patient I might see TWICE -- see, send for test, then see again. I want to track all patients throughout day with a visual of time spent per patient and time spent charting/doing admin. Does that make sense? Can you help with this? It doesn't even need to look pretty :P

[@nehajaihind]

excellent one. Please guide to make different days with time and task for production. This chart happens for one day.

[@theoklingels3058]

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

[@PKAnExcelExpert]

Yes you can use it

[@peternganga9371]

Beautiful and well presented, as usual.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@safetymanagementsystem4903]

PK sir your videos are too nice and informative

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@egmedo1407]

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

[@PKAnExcelExpert]

Most welcome🙏

[@happylife1000]

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

[@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

[@AbhishekMishra-cr1tz]

Very Nice video for learning thanks sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@umitozay6566]

excellent job, thanks PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mismar18]

Awesome Work, much appreciated

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@KhalilAhmad74036]

Awesome Work, much appreciated, Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@charantyrekhanna7191]

Thanks for video's

[@PKAnExcelExpert]

Welcome

[@texculp67]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@srikanthchs7255]

Excellent.

[@PKAnExcelExpert]

Many thanks!

[@yuwenchen3457]

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

[@rafakiyo]

great job!

[@PKAnExcelExpert]

Thanks

[@animzing4413]

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

[@PKAnExcelExpert]

Sure, will trust to create

[@ArmanKhan-iq3ji]

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

[@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.

[@gilsoncosta6869]

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

[@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

[@mandarsm1]

Thanks!

[@PKAnExcelExpert]

You are very welcome🙏

[@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

[@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?

[@romlef526]

Beautiful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@souviksengupta2873]

Superb 👍👍👍

[@PKAnExcelExpert]

Thanks

[@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

[@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

[@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

[@danimordecai7611]

wow

[@PKAnExcelExpert]

Thanks🙏

[@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

[@chikeziechekwas243]

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

[@josearmaza863]

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

[@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!

[@GaneshSutar-mf7bs]

How to dynamic the same with date change

[@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

[@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?

[@sajeerks1708]

You can make dynamically chart through convert table range.

[@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

[@A-Beats-R]

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

[@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..??

[@iftikhardba]

How can we change time column to dates?

[@sohilkhasatiya2984]

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

[@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.

[@karanpatil7887]

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

[@biancameeuwissen4542]

always long to see your skills

[@shenoudamedhat4892]

Can you make a massage reservation vba please

[@wildherbs7693]

make recepie costng please

[@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

[@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.