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 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
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?
@@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...
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 !
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.
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..??
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.
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
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
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
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.
Thanks!
You are very welcome🙏
Excellent Tutorial and well explained. Thank you so much.!
Most welcome🙏
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
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
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
PK sir your videos are too nice and informative
Thanks for your valuable feedback
excellent job, thanks PK
Thanks for your valuable feedback
Awesome Work, much appreciated, Sir
Thanks for your valuable feedback
Awesome Work, much appreciated
Thanks for your valuable feedback
excellent one. Please guide to make different days with time and task for production. This chart happens for one day.
PK Very well done my friend!! I enjoyed the tutorial immensely!!! :-P Thanks for sharing!!
Thanks for your valuable feedback
Thanks for video's
Welcome
Superb 👍👍👍
Thanks
Thank you very much.Can be used as example for daily workplanning.
Yes you can use it
I don't know what to say but thank you so much
Most welcome🙏
great job!
Thanks
Excellent.
Many thanks!
Your presentation of work is becoming exceptionally good. Keep up tthe good work and thanks for the share.
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
Beautiful
Thanks for your valuable feedback
PK, great work. How to add an additional beginning date & end date to the template?
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 please make a video of sales dashboard on car's industry please.
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?
Hi. Can you make an example like this using only conditional formatting. Thank you
Sure, will trust to create
V nice
Thanks for your valuable feedback
PK, congratulations, excellent. Its possible to change hours per days?
Great video. How to add one or more bars in the same row? Thanks.
Add the data in the table to add more bars
Thank you PK. I noticed the Doughnut pie chart isn't dynamic.
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
Amazing bro 👍
Thanks for your valuable feedback
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?
You can make dynamically chart through convert table range.
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.
Great, PK. Another excelent and instructive video. Please, could you check the download link, I could not download the file.
How to dynamic the same with date change
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!
Hi PK , Can we make out chart dynamic by simply converting our data into table. Plz reply
I wanna ask the same question
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. 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.
Hi Ok, can you make macro for multiple pdf file move in ppt
How can we change time column to dates?
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..??
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
wow
Thanks🙏
Can you make a massage reservation vba please
Dada, Can you make a project risk analysis in excel next time?
Sure,I will try to make such video
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.
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
always long to see your skills
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
Dear sir ,pleases next time dashbord in Collection( Recovery) excel vba
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
make
recepie costng please
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.