Dynamic Hourly Project Planner (Gantt Chart)
Вставка
- Опубліковано 16 жов 2024
- #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-anexcel...
Download the Free Project Management Dashboard
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
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-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...
PK, I like all your topic videos and files so much, thank you for sharing them. I can say all are very awesome.
Thanks for your valuable feedback
Your ingenuity continues to be a cut above; thanks for sharing
Thanks for your valuable feedback
Excellent Tutorial and well explained. Thank you so much.!
Most welcome🙏
excellent one. Please guide to make different days with time and task for production. This chart happens for one day.
Thank you PK I really enjoyed making that chart. It's a beautiful chart and you showed very useful techniques. Thank you.
Thanks for your valuable feedback
Beautiful and well presented, as usual.
Thanks for your valuable feedback
PK sir your videos are too nice and informative
Thanks for your valuable feedback
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
Will upload soon
@@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
I don't know what to say but thank you so much
Most welcome🙏
excellent job, thanks PK
Thanks for your valuable feedback
PK, great work. How to add an additional beginning date & end date to the template?
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?
PK Very well done my friend!! I enjoyed the tutorial immensely!!! :-P Thanks for sharing!!
Thanks for your valuable feedback
Awesome Work, much appreciated
Thanks for your valuable feedback
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
Thanks for video's
Welcome
Thank you so much for sharing this important information..very useful.. Keep us guiding like this..
Very Nice video for learning thanks sir
Thanks for your valuable feedback
Thank you very much.Can be used as example for daily workplanning.
Yes you can use it
Awesome Work, much appreciated, Sir
Thanks for your valuable feedback
great job!
Thanks
Excellent.
Many thanks!
Hi. Can you make an example like this using only conditional formatting. Thank you
Sure, will trust to create
wow
Thanks🙏
Your presentation of work is becoming exceptionally good. Keep up tthe good work and thanks for the share.
Thanks for your valuable feedback
PK, congratulations, excellent. Its possible to change hours per days?
Thank you PK. I noticed the Doughnut pie chart isn't dynamic.
Thanks!
You are very welcome🙏
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?
Hi PK , Can we make out chart dynamic by simply converting our data into table. Plz reply
I wanna ask the same question
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.
will try to create a video on this topic
Great video. How to add one or more bars in the same row? Thanks.
Add the data in the table to add more bars
Beautiful
Thanks for your valuable feedback
Superb 👍👍👍
Thanks
Thanks for video please make a video of sales dashboard on car's industry please.
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.
Great, PK. Another excelent and instructive video. Please, could you check the download link, I could not download the file.
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 !
Yes you can!
Can I Use this for my project? Please advise what precautions I need to take? Is there any template? Eagerly awaiting your reply.
You can download this template. Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
V nice
Thanks for your valuable feedback
How to add and manage dependencies within tasks? This works great for me except for the missing dependencies
Will create another video with dependencies
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..??
Fantastic gantt. Very useful. How do I increase the chart to include 24 hours?
Thanks. You can add the date with time and reset the horizontal Axis option to Auto
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.
Thanks for your valuable feedback
@@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...
@@PKAnExcelExpert good job bro
@@PKAnExcelExpert great job bro
My name is Priyendra Kumar.
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.
How to dynamic the same with date change
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
Hi Ok, can you make macro for multiple pdf file move in ppt
Dada, Can you make a project risk analysis in excel next time?
Sure,I will try to make such video
How can we change time column to dates?
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
Can you make a massage reservation vba please
Amazing bro 👍
Thanks for your valuable feedback
Dear sir ,pleases next time dashbord in Collection( Recovery) excel vba
You can make dynamically chart through convert table range.
The time formula is not getting applied
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
always long to see your skills
Hamko excel dashboard banwana hai
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.
make
recepie costng please