Power Gantt Chart (Project Planner) for Project Management
Вставка
- Опубліковано 16 жов 2024
- #Project Management #PowerPivot
Hello Friends,
In this video, you will learn, how to create a Powerful Gantt Chart (Project Planner) for your Project Management Dashboard. We have used Power Pivot to create this chart. This is a dynamic Gantt which can be controlled by different slicers and Timeline.
Download the practice file from below given link:
www.pk-anexcel...
Learn how to start with Power Pivot in MS Excel-
• Data Modeling: Create ...
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/...
This chart has worked GREAT for me and my team here at work. However, now that the new year has begun it no longer works. I am going to re-write it but wanted to bring that to your attention. Thank You so much for this as it REALLY helped me and my team.
Sorry to hear that. I will look into this and will create another version of it.
No Problem! This has helped me and my team so much. I just re-created it using 2024 date. If we were able to create another calendar and use the same database would be great. TY Again!!!!@@PKAnExcelExpert
in your power pivot once you create a calendar view as mentioned by PK sir. Go to Manage tab in powerpivot on the dashboard >Design> DateTable> Choose last option update date range. Choose your desired number of years and it gets updated. I hope this helps.
You are flat out AMAZING. I have looked at your tutorials and the outcome. I have followed you step by step and had the same results as you did! That's the sign of an excellent and proficient video and great skill and talent that you have. I'm just very appreciative because I needed something like this to track projects and it looks and works beautifully. Keep up doing what you are doing and thank you very much for not being a stingy selfish person like so many are, who don't share this knowledge and these examples. Very much appreciated. Have a wonderful year!
Mr PK. No one beat you in this filed.. you are.king maker in excel
Thanks for your valuable feedback
Thank you sir , you have solved so many problems in one video
Most welcome🙏
Thank you Mr. PK for sharing this excellent tutorial! You know exactly your viewers expectations. Impressive!
Thanks for your valuable feedback🙏
This is an excellent tutorial. Very generous to share the work, much appreciated.
Thanks for your valuable feedback🙏
Amazing work. Excellent work .. Thanks alot
Most welcome 😊
This is an absolutelu great Idea! Thank you!
You are so welcome!
Excellent work no doubt and request you to add the following things to make it more professional
1.) Add a off day date column in the Gannt chart
2.) each bar should show the progress in number aslo(59% and example)
3.) it should also show the plan progress
Thanks
Mr. PK, you are great mentor. Stay blessed
Thanks for your valuable feedback.
This video is amazing. It is precisely what I've been searching for in the last few months. This Power Gantt Chart is a huge hit within my organization. However, I've noticed that sometimes, not all the data gets updated on the pivot table. How is this possible, and how do I fix it? For example, on the data table, I would have entered the name of the employee and the task name that is associated with it. Once the data is entered and the pivot table is refreshed, the employee's name showed up, but not the name of the task. Please help me resolve it, thanks.
Very Nicely Explained.
Thank You Very Much...
You are most welcome
I was eagerly waiting for the next video but it didn't come up. So now I have a request to you, pls start posting power apps and power automate videos and we know thats the next generation way of smart work and it gonna change the era.
Thanks in advance
This is excellent Video ,very detailed and correct . Thank you so much !!
Thanks for your valuable feedback🙏
Superb explanation and I am happy it's very easy to learn too
Thanks for your valuable feedback
Absolutely great tutorial, thxx
Glad you liked it!
Excellent Work and excellent Tutorial!
Thanks for your valuable feedback
Dear PK ji
Your each and every vedio materials are very unique and excellent.
I heartily appreciate your vision and mission.
Thank you Sir
For this excellent tutorial 🙏
Thanks for your valuable feedback
Its really awesome video. Thumbs up for you and i have one suggestion to improve it further. Instead of having completed and in progress, data bar selected by default for 100% and in that bar, progress showed.
Love this, excellent .. thanks
But How to get or adding conditional weekend & weekdays for your workbook ?
PK, I have been using this for months at work now! Thank You so much! I am using it as a Project Calendar but was wondering if you can show us how to Auto hide rows based on a specific set of conditions. Specifically in my case, TODAY()-30. Thank You and I hope you respond!
Excellent video, thankyou PK. I have been using this to great effect for planning when my trainees are likely to complete their training, depending on when they pass each milestone. I have recently come across a snag with MMM-YYYY sorting. Initially it was fine when it was only for year 2021, but now I need to move into 2022, whilst still displaying 2021 information. Sorting the MMM-YYYY column by Month number now puts Jan 22 right after Jan 21. Can you advise how I can get around this problem.
I am also interested in hearing PK's solution. To get around this problem right now in the Calendar tab of the Data Model I've added these columns (I'm also trying to use week numbers):
'Quarter' (='Calendar'[Year]&"-Q"&'Calendar'[QuarterNumber]) which gives something like 2021-Q4, 2022-Q1 etc.
'Week Number' (=weeknum('Calendar'[Date],21)
'Month' (=FORMAT([Date],"MMM"))
In my Pivot table the columns I've added are Quarter, Month and Week Number. This has almost everything in the right order EXCEPT I seem to have week number 52 showing up as a column in January 2022-Q1
Jan
1, 2, 3, 4, 5, 52
Feb
5, 6, etc
I'm not sure why 52 is showing up there between week 5 and 6!
@@traciottawa same here - did you get any respons on your Q?
@@larssandgreen5464 nothing so far. I keep hoping 😝
I found the solution to this here. The trick is to create a new year month sort column by adding the year and month together.
ua-cam.com/video/TFStPQGqD2I/v-deo.html
Hello Sir,
I am inspired with your videos and they are very much helpful. I was trying to create a similar Gantt chart with few changes. Like in my case during an activity If it goes to on Hold state for 2-3 days then I need to add those days in timeline with a different color for that particular activity when the it was On hold. In data table I have added the OnHold start date and end during the activity duration. But now to show visually I wanted to add a measure as below... but could not do that. Can you please suggest?
++++++++++++++++++++++++++++++++++++++++++++++
=Var OHStart_Date =MIN(Table1[OnHoldFrom1])
Var OHEnd_Date = MAX(Table1[OnHoldTo1])
Var Column_Date = MIN('Calendar'[Date])
Return
IF(OHStart_Date=Column_Date,0)
+++++++++++++++++++++++++++++++++++++++++++++++++++++
Great going
Sharing knowledge and making others learn is a great deed
Thanks for your valuable feedback
Very good and useful. Thx
Thanks for your valuable feedback
This is awesome. Thanks!
You're very welcome!
Loved the Video - amazing work. Had it all done easily. Thank you.
Thanks for your valuable feedback
Dear PK, your video Tutorial very helpful for my Job.
In this video I use your file and try to make a little modification to add week abow date row, but it's not work properly.
Can you help me to solved the problem.
Thanks in advance
Excellent sir
I have not seen this video sir
Superb sir
Excellent and very useful.
Thanks for your valuable feedback
thank you for this. i can use for Vacations (annual - occasional - sick - lay - without pay) and employee work
Hi sir. Thanks a lot for your tutorial. So I have small marrer, when we added some formula to Excell work sheet any column, so how to keep active and safe the formula without deleting or damage.
Excellent, Thanks
Most welcome
Excellent PK, thank you for showing me this.
Thanks for your valuable feedback
Great tutorial and very clear explanations. Thank you for sharing your knowledge.
Excellent Guru Ji.
Hi Master, very nice useful Gantt chart. Thank you so much.
I request you to kindly provide solution on the same GC. for the below 3 Reqs.
1. Need a time line with light color code for from the start and end dates.
2. Need a %Completed column and a progress bar based on %comp. With dynamic RYG colors. Formula 50%and =80 Green dynamically to be Displayed on top of timeline light color Bar.
3. And on top near by slicers a round circle RYG.
4.Able to embedd on PPT to present dynamically.
Please.... Master.❤
Thank you 😊
Solution on each task level and as per slicer level.
Please acknowledge sir
Excellent job
Thanks for your valuable feedback
Hi gentlemen Many thanks great works,
Thanks for your valuable feedback
Wow, excellent, PK. Thank you.
Thanks for your valuable feedback
Wonderfull my friend, nice your tutorial...
Great. Keep up the good work. Very good sharing. Where should I go to change the year & month
Hey PK, thank you for the video. Do you know if we can use your video for 1/2 PDU for PMP?
Thanks for the great gantt chart 👍👍
May I know how can I change or extend the date range without power pivot install? Thanks in advance.
Great Job!
Please help me, how can I extend the calendar to 2021?
Many thanks!
Go to power pivot tab, select Manage. Once your time table sheet has opened, go to date table within the tab Design and select Update Range to add more years.
Fantastic tutorial!!!
Thanks for your valuable feedback
Hi Sir - Excellent Tutorial. I can't seem to download the Practice File. Is it still available? Kindly advise.
You can download it from below link:
www.pk-anexcelexpert.com/power-gantt-chart-project-planner-for-project-management
Pk sir. I have done steps for conditional formating but not getting out on pivot. Hiw to fix .cond formula is ok.
You are awesome
Very nice thank you
Thanks for your valuable feedback
Hi, can I ask your advise? I can't click the "NEW" in Power Pivot for Excel, in design tab (6:14 in the video)...I followed all the steps but not sure why it can't add the calendar....Thanks for answering in advance!!
Is there a way to download the file. I have rebuild do far on my own, but the sorting of the timeline doesn’t work. @ 14:25. Thank you very much.
Thanks 😇
Welcome 😊
PK sir, could you make Gantt chart with dynamic dependency which changes the Gantt chart automatically means how to add predecessors dynamically
Will upload soon
thank you sir . its very useful to me .. i have one doubt . is it possible to add working time in gantt chart ? how to add ? if start date with dd:mm:yyyy hh:mm formate
Will try to add in next version
@@PKAnExcelExpert thanks for reply. I will wait for your next version..hope will release soon 🙏
Excellent Mr. PK. Is there a way of doing it in 2013 "Calculated Field"?
Can it sun the hours by week or by month w.r.t Resource
Excellent tutorial, One question. How can I include year if the project has 2020 and 2021 year plan. thanks
got it after careful review in calendar table. thanks
@@siblingsjoy9531 Can you possibly share how you solved for your sorting to get multi year to work?
@@alexandrawoods3037 same here - did you find out about year extension?
How do I make bars on gantry chart populate by the week and not days. This way I don’t have to keep scrolling to the right. Also add a conditional format to highlight start of week when I open file?
Hi - It was an excellent tutorial. When I tried to create new measure with the same variables defined, I am getting an error "The expression is not valid or appears tobe incomplete. Please review and correct the expression.
Pl advise
Hi - Can you pl advise
Hi your video is very usefull.
But when I did it, I am getting Jan 2024 and then Jan 2023 next to each other.
Please let us know how to fix this
Will create another version of it and will fix the issue
@@PKAnExcelExpert thank you for reply sir
Can you start on a certain date and can you go beyond 1 year?
Awesome sir!
This is a great video. The code written on the measures are failing. It's throwing an error as "The expression is not valid or appears to be incomplete. Please review and correct the expression." May I know how to fix this issue.
i have the same problem did you find the soluotion?
Hello, I’ve added 12 months of 2021 to 2020. I can;t seem to make Jan 2020 appear first in the horizontal sort. I am sorting as you’ve indicated MM-YYYY. It seems to be displaying 2021 first. When I sort by YYYY only, of course I lose the MM. Would you know a way to do this? Thank you! :)
Iam downloaded your given power pivot link and I updated my data but I couldn't able to get the chart
Very useful indeed, can I get this excel sheet format or download ?
Thanks for your valuable feedback. Please download this excel file from the link given videos description box or visit our website Www.pk-anexcelexpert.com
Many thanks 🙏🙏
Most welcome
Is there a way we can make it weeks instead of days in the month.. in the columns?
will try to add in the next version
I updated the date range in the data table to include 2021 through 2025, i close out Power Pivot and table updates, then i refresh and all my months duplicate I get Jan 2022 and Jan 2023 next to each other, how can I fix this?
please make it to google sheet..
by the way, I really love this tut
Sir,
I want to make display the selected Database fields in a list box .
For Example , Not like this :
.lstDatabase.Rowsource = “Database!A2:V” & iRow
Like this :
.lstDatabase.Rowsource = “Database!A2:F” & P2:V” & iRow
Please Help...
Great
Thanks for your valuable feedback.
Can you do a progressive maintenenace schedule?
Excellence !!!!
Thanks for your valuable feedback
how this will work when the start date is dec 31 2021 and end date is 31 jan 2022?
the measure is not working as shown . please explain
Could we add the Percentage progress into each bar with 2 colours like Completed and In progress with the percentagr portion?
@D L i watched another video with two rows for Planned and another of Actual progress. It would be too massive when too many projects.
Yes it must be a formula to add, do u think it shall add into the Data Of Power Pivot also?
THANK YOU PK for the tutorial just one thing that i found when i needed to creat my formulas on mesures for the powe pivot i had an error when i tray to creat the result logic maybe beacause i'm using microsoft office 2019 so i change it to this :
=
VAR Start_Date = MIN(Table2[Start Date])
VAR End_date = MAX(Table2[End Date])
VAR Column_Date =MAX('Calendar'[Date])
Return
IF(Start_Date=Column_Date; 1;BLANK())
so replacing the , by ; for result true if = 1 or ,balnk by :blank and its work fine
thanks
hi there PK, how could i add data validation or dropdown menu for the status of each task? so that i can easily update my status in the gantt chart and no need to go to data sheet. thanks
hey I have a question, what if I dont want to have the date and the month in the horizontal axis but the START TIME (e.g. 09:00) and the END TIME (09:30) of the meeting? How can i edit that?
Hello PK, thank you for your insightful videos. I am still learning everyday with your tutorials. However; i have been trying to download your tutorial from your website and I am getting an error 503 Service Unavailable. Any help will be greatly appreciated. Thank you
Project delay and extended also could we highlighted ?
Yes, We need to modify accordingly.
Excellent helpful video! I would like to know how I can add add'l years. I have not been able to get the sort properly.
Go to power pivot tab, select Manage. Once your time table sheet has opened, go to date table within the tab Design and select Update Range to add more years.
>>>>>>>Hi. could you tell us how to create multiple task dependencies formula in excel. I have Task G with 3 predecessors. Task G start or finish date should change based on predecessor tasks. IS IT EVEN POSSIBLE???????
HI, COULD YOU EXCLUDE WEEKENDS?, SHOWING A GRAY COLOR ON THOSE DAYS?
Yes, we can do that
@@PKAnExcelExpert could you send me the code to add?
Selam gardaş , creative userform tasarımları bekliyorum senden ,sen bu işi çözmüşsün harikasın ...selamlar saygılar
Excellent
But when I try to add task, it doesn't appear on the sheet
How do you change the year to 2023
=
Var Start_Date =MIN(Table1[Start date])
Var End_date=MAX(Table1[End date])
Var Column_Date =MAX('Calendar'[Date])
Return
IF(Start_Date= Column_Date,1,BLANK())
what is the problem in this formula ?
PK that was a great tutorial, you made it seem so easy, and indeed after trying your way it is. I would like to recreate the calendar table to have each hour of the day split by every 15 minutes, could you help me with that? Thank you so much!
i dont mean to be so offtopic but does someone know of a tool to log back into an Instagram account??
I was dumb forgot my account password. I appreciate any tips you can offer me!
@Emmitt Cairo instablaster :)
@Tomas Noel I really appreciate your reply. I got to the site through google and Im waiting for the hacking stuff atm.
Looks like it's gonna take a while so I will reply here later with my results.
@Tomas Noel It worked and I finally got access to my account again. I'm so happy:D
Thank you so much you saved my ass!
@Emmitt Cairo happy to help :D
Please can you let me know how can I add another year to my dates... my project runs into 2022
Go to power pivot tab, select Manage. Once your time table sheet has opened, go to date table within the tab Design and select Update Range to add more years. Good luck 👍
thank you so much, i have been starting my Chart all over again to add more years before this solution works perfectly.@@sebastiancavallo9421
Hi Sir,
Can you help me with a macro file? My requirement is I want to change some data in multiple workbooks and within these multiple worksheets from a master file. Please help me & post related tutorials. We are expecting within a short time we get the video from your end. Advance Thanks.
How to create this in google sheets
HOW DID YOU REMOVE THE FILTERS
Great session - I tried to follow it - but the expression used to create measure kept on giving me error - any idea why please - I followed them step by step
I am also facing the same problem
Not able to create the measure
How can I highlight Today's date? I tried everything but with no success. Can anybody help?
=IF(AND(NOW()=BK$10),"|","") In each cell, which will draw a vertical dashed line down the page at today's date.. BL$10 and BK$10 refer to the top line that has the date in it. The logic is if this date (Column BK) is both greater than today's date after midnight and less than tomorrow's date at 00:00:00, it must be today. Remember that NOW() is the date and time of day between 12:00:00 AM and 11:59:59 PM. Same formula works whether days, weeks or months.
@@billhitchcock9410 Thank you for your answer. Have you tried to apply this formula in the specific Gantt Chart file? I’m asking you because I tried to use other formulas with same results but unfortunately I can’t apply anything in the row which shows the date of days. I will appreciate it you can check your suggestion in this file
Video fonts not visible sir
How do I get the tab of power pivot
Watch our Power Pivot playlist
ua-cam.com/play/PLbDvAYjpWJ7BkZVdyETS4Ec6H_xHrqzzu.html
Sir amazon flipkart online account ke reconciliation btao