Gantt Chart in Microsoft Excel | Project Planner Template in Excel - 1 of 2
HTML-код
- Опубликовано: 21 авг 2024
- Microsoft Excel - Gantt Chart
In this tutorial, we will show you how to create a Gantt chart in Microsoft Excel. First, we will show you how to create a Gantt chart in Excel using a pre-made template. Then, we will show you how to create a Gantt chart from scratch.
Creating a Gantt chart in Excel is a great way to visualize your project. By using a Gantt chart, you can see the start and end dates of your project, as well as the timeline of each task.
There are a few reasons why you might want to use Microsoft Excel as your project planner. First, it's easy and free if you already have Excel. Second, you can use Excel to create a Gantt chart, which is a great way to visualize your project plan. And third, you can customize the template to fit your specific needs.
How to Customize Microsoft Excel - Gantt Chart Video,
• How to Customize Proje...
#projectpan #ganttchart #ganttchart
Thank you, I didn't think to look for a template. That makes is so much easier.
You are welcome.
Tu viens de me débloquer la frere wAllah t’es un monstre merci le sang
Dear Wassim, I can only understand English I tried to use google translate but still unable to understand your message. thanks
7:57 adding project days : validation : list > any values
9:42 need to extend conditional formatting
11:00 finding formulas for bars
Hi, to customize please check 2nd video link the description. Thanks
Great content, congrats!!!!
Thank you so much 🤗
I like how you start with the name of Allah.
Jazakallah khair
Thank you!!!!Perfect!!!
You're welcome!
Thank You Sikandar Bhai I need this next Week...So very Use full for me. :)
Appreciate Video clip! Sorry for butting in, I would love your opinion. Have you ever tried - Weydaniel Organized Dominator (do a search on google)? It is a good one of a kind product for getting 7000 plus project management and business templates minus the headache. Ive heard some super things about it and my work colleague after a lifetime of fighting got astronomical success with it.
This was excellent video. It helped me so much. Thank you
Welcome
Thanks sir for this video it really helped me.
Thanks for the Video! Sorry for the intrusion, I would appreciate your initial thoughts. Have you tried - Weydaniel Organized Dominator (probably on Google)? It is a good one off guide for getting 7000 plus project management and business templates minus the normal expense. Ive heard some decent things about it and my old buddy Taylor got excellent results with it.
So helpful, thank you!
Glad it was helpful!
Excellent video thanks from Jordan
You are welcome. Thanks
Good tutorial, thank you.
You are welcome
Wa alaikumussalam -very useful -Thank you
Thanks for liking
very helpful!
Glad it was helpful!
What will you do if there is intermittent schedule in completing the project? How would you show it in the excel?
Hi please have a look at this video to customize the template and if still any question please share at info@erpstuff.com
ruclips.net/video/W8E6oH_pqAk/видео.html
Thank you, it is very helpful
You are welcome.
Thank you so much...this is life saver.
Thanks for sharing this.
Tysm, Sir 🙏
Thanks bro zajakAllah
Welcome...
Great Video. How do you change the colour of the chart, would prefer to choose RAG colours
You can change colours in conditional formatting. Thanks
Salam, thank you for the video. Is there a way to change the day start and actual start to a DATE instead on day 1 or etc. And the period to become week/month like in a calendars? Thank you.
Salam dear you can check the 2nd video how to customize this template is explained and find a way if you can as I never tried link of video is in description of this video. thanks
thank you sir
You are welcome..
thanks sir
Welcome
Thank you 🌟
You’re welcome 😊
Thank you so much.
You're welcome!
Waslam, perfect, thanks
Welcome...
Really helpful! Thank you😭🦋
You are welcome
It was so useful for me thanks a lot
Great and please check 2nd video to know how to customize this and link is there under this first video. Thanks
Excellent, how does one change the duration tonactual dates ?
Please check video 2 of 2. thanks
👍👍
Thanks
Can you change the period to dates, like one column equals one week? I have project that last 3-4 years. How can you do that?
Hi Anna, Here is a way as per my understanding from your comment, hope it will address your challenge.
www.erpstuff.com/forums/viewtopic.php?f=53&t=10956
ruclips.net/video/W8E6oH_pqAk/видео.html
Thank you for helping us. How to download this template?
It will be there in Excel. Thanks
hey, i have problem where i enter the actual start for example day 5 and it goes to day 4. How can i fix it?
Hi, Please have a look at the 2nd video on same topic to customize this template, if still not clear please let us know at info@erpstuff(dot)com
MS Excel Project Planner (Customization)- Gantt Chart 2 of 2
ruclips.net/video/W8E6oH_pqAk/видео.html
If the plan day is 0.5 (half day) , how can I change the formula on the file?
Hi, Have you tried as explained in the video, but per cell is considred as 1 day and you can't split cell to half so will be tough. May be a different color of the cell but never tried.
ruclips.net/video/W8E6oH_pqAk/видео.html
Thank you
How do you change the number 9f days to actual dates ?
Hi, Please check 2nd video 2 of 2 showing how to customize this template. thanks
Hi, how can you change the days into months? Because now you only see the days since start, but it is impossible to see the actual period of time for example from January 2020 until March 2020.
Please share a sample excel file at info@erpstuff.com
@@ERPstuff that question is similar to mine. I need weeks with dates.
ruclips.net/video/W8E6oH_pqAk/видео.html
Can we use using time (hr) instead of day?
Kindly share your excel file the way you want let me see at info@erpstuff.com
try this way if you like it,
www.erpstuff.com/forums/viewtopic.php?f=53&t=10956
ruclips.net/video/W8E6oH_pqAk/видео.html
How do you add dates instead of numbers for periods?
Hi, The easiest way is to add an extra line above days and merge cells by month+year. If the first 31 days are of Jan-2020 then merge 31 columns and make them Jan-2020 as it will keep your sheet/data limited to scroll right. Let me know if this is fine with you? thanks
@@ERPstuff very very helpful,, really thank you very much
Dear I request you to give the clear formula or please explain about how creat the formula
In the description, you can find video 2 explaining how to change template
How to add dependencies in the chart
Add a column and enter dependent task no if any.
@@ERPstuff how to add finish to finish etc dependencies
How to customize this template explained here,
ruclips.net/video/W8E6oH_pqAk/видео.html
Sir, Would you please let me know the formula of Periods, How to change the color of activities
Hi, You can change conditional formatting while unable to understand the formula question. Planning to record another video to show how this template can be customized. Thanks
@@ERPstuff Dear Sir, can you share another video link. Its really help full for me.
ruclips.net/video/W8E6oH_pqAk/видео.html
Can we edit the instruction as well when we increase or decrease the period, if so how?
Which instructions? Yes you can add if still further details required share it with info@erpstuff.com
ruclips.net/video/W8E6oH_pqAk/видео.html
Please give me as tamplate so that I can use it for my work
It is there in Excel and explained in video. Thanks
How do you adjust the maximum of 60 days?
Hi, please check 2 video and link is there in the description of this video. Thanks
Thank you, could you please provide the example data?
Dear Sarah, This is an Excel template and sample data is already there. In excel click File > New and then Planners and Trackers and you will find there just used which you like. Let me know if still any query. thanks
Can u change number in date
Hi, please check 2nd video how to customize this template link in description of this video as unable to understand what exactly you are looking for? Thanks
How to separated year in the gantt chart?
Hi, i will release another video to share how to customize template. Thanks
ruclips.net/video/W8E6oH_pqAk/видео.html
Period ke jgah pr dates kaise add kre sir?
Hi, Please check the 2nd video to customize this template and the link is there in the description of this video. Thanks
can you change the colors?
Hi, Yes you can change from conditional formatting. Let me know if still any challenge. thanks
ruclips.net/video/W8E6oH_pqAk/видео.html
How to add it month wise?
Please check video 2 of 2 how to customize template and link is there under this video. Thanks
Sir, how to change color arch?
Hi, Conditional formatting....
ruclips.net/video/W8E6oH_pqAk/видео.html
How to make this chart please help me
In video all explained if still any question kindly share. Thanks
how to calculate the %?
Hi,
Please go through 2nd video on this to customize this will give you an idea. Link is already there in the description of this video of 2nd video. thanks
How do i download the template
Hi, it is there in your excel by default. Thanks
How do I insert sub-task ?
Insert row and copy from another row will copy all formulas and formatting. Hope this will work for you. Thanks
You can do the change
ruclips.net/video/W8E6oH_pqAk/видео.html