@@teresaanthony9633 Hi there, we're just creating a chart using the start dates as Y-axis. If you configure your dates quarterly-wise, then your gantt will look like 3-month chart. But please keep in mind that this gantt is to track tasks according to their durations, so making quarterly gantt may not be appropriate always. Hope this helps!
We're so glad to hear that. As an additional note, if you need a more complex and ready gantt, you can also check out our tool: www.someka.net/products/gantt-chart-excel-template/ Thank you so much.
Hi there, you can play with the chart formats to get a better view. Right click on the date axis and go to Format Axis panel. There, you'll find setting options for text, fills, label position, number format, etc. Hope this helps!
Hi there, you can add completion % with Conditional Formatting > Data Bars in Excel. First, write your completion percentages and then add conditional formatting for a visual representation. Hope this helps! You can visit our Conditional Formatting Guideline for advanced tricks: www.someka.net/blog/excel-conditional-formatting/
Hey there! Please ensure that your data is formatted correctly. Select your input date data, right click, and choose Format Cells. Under Category, select Date and your preferred date format. Hope this works for you.
Hi there! If you want to remove the gaps between the orange bars, select them by right-clicking on them and choose "Format Data Series" on the menu. Then, go to Series Options on the side bar and decrease the Gap Width to 0% and increase the Series Overlap to 100%. This will remove the gaps between orange bars. However, if you want to adjust the intervals of horizantal axis (date intervals), you can right click the dates > Format Axis > Units and you can write how many days you want the intervals to be on the Major box. Hope these answers help! If you need further assistance, you can also contact us via contact @ someka . net
hi there, we're using chart method here, and the dates are only the axes data of this chart. So if you use timings (which excel also let you do), then your chart will be formed based on the timings, not the dates. Hope this helps! For other methods to make Gantt in Excel and more detailed information, please visit our article: www.someka.net/blog/how-to-make-gantt-chart-in-excel/
Thank you for reaching. You can use Start Dates and Duration as series in this chart. But here's a complete guide of this tutorial: www.someka.net/blog/how-to-make-gantt-chart-in-excel/ Hope this helps!
Hi I want the date axis to start with the given date and not something random, how can I adjust these dates on axis, it is automatically predating couple of months
Hi Sundeep, you can try giving 0 to the start date of the first task and then manipulating the start dates of other tasks accordingly. But this will need of course some workarounds on the data. Because this is a very basic way to create gantts. If you need a more professional solution, please try our Gantt Chart Template: www.someka.net/products/gantt-chart-excel-template/ Thanks again for your comment.
Hi there, there's chance your file is on manual calculation mode, instead of auto-calculation. Or there might be some jumps on the formula. Maybe you can just send us your file at contact@someka.net, and we can check it out. By the way, also do not forget to check our ready-made gantt chart templates: www.someka.net/products/gantt-chart-excel-template/
But I dont want to see sunday days because I dont work sunday. What should I do for duration box. I should write new formul in duration box. But What ?
Hi there, thank you for asking. You can use the WEEKDAY function to check if start or end date of your tasks is a sunday or not and then increase the number of duration if any of them includes a sunday. Hope this helps! But if you're looking for a more complex gantt, you can try our product: www.someka.net/products/gantt-chart-excel-template/ This template has a settings part where you can exclude any weekday from your gantt automatically. Thank you!
Hi, do you have any video where suppose i have fix set of activities to be performed. Each activity may be sub activities. Like if 1 st activity has 1000 sub activities we say that 500 is complete. The we show status showing 50% is completed. Next week if we complete 250 out of remaining 500. So status updates to 75% complete? What i can use for that ?
Hi there, thank you very much for your question. Actually we do have an Action Plan Excel Template, designed to track the progress of many actions under specific goals. We think this might be highly interest you. You can just have a look and download free version to test it out: www.someka.net/products/action-plan-excel-template/ Thank you!
Hi, this method is actually an workaround on the simple bar charts. So you can use the same logic on any other platforms, which may include the power Bı or other spreadsheet software. This is an Excel exemple, and include the excel chart features. Thank you!
Hello, once you insert the chart, right-click on the chart>click Select data>click Add and add duration cells to series name and duration values to series values. The orange label will appear.
Hi there, this is a tutorial video to build gantt charts in excel. If you're looking for a ready-to-use tool, just check our Someka Gantt Chart Maker: www.someka.net/products/gantt-chart-excel-template/ Hope this helps!
Well, all videos on TH-cam do the same as you do, i.e. create the chart first and add "Duration" later. I wonder why don't you select two data columns at the beginning and create the chart at one go. As simple as that.
Hello, thank you for your question. If you select both start time and duration at the same time and insert the chart, it won't create the Gantt chart properly and won't create the orange areas on the bars.
![🎤 ไปกันต่อออ! จับฉลากร้องเพลง x P’ #XXSIVK [EP.2] (1/2) เพลงของใครจึ้งสุดน้าา 💓🎤 #MXFRUIT](http://i.ytimg.com/vi/mLI_K0sAS4o/mqdefault.jpg)
straight to the point. thank you
Most welcome :)
@@SomekaNet this is amazing how can do this quarterly wise?
@@teresaanthony9633 Hi there, we're just creating a chart using the start dates as Y-axis. If you configure your dates quarterly-wise, then your gantt will look like 3-month chart. But please keep in mind that this gantt is to track tasks according to their durations, so making quarterly gantt may not be appropriate always.
Hope this helps!
Thank you very much! Very useful!
We are glad to hear that :)
Very useful. Saved my assignment
Thank you! We're so happy to hear that!
Thank you so much
Great video! i was losing my will to live working out how to do this
We're so glad to hear that.
As an additional note, if you need a more complex and ready gantt, you can also check out our tool: www.someka.net/products/gantt-chart-excel-template/
Thank you so much.
How do you fix the dates at the top of the chart? They're jumbled
Hi there, you can play with the chart formats to get a better view. Right click on the date axis and go to Format Axis panel. There, you'll find setting options for text, fills, label position, number format, etc. Hope this helps!
Thank you. It's very helpful
Glad it was helpful!
Awesome!!!😊
Thank you :)
Thanks so much, short to the point and helpful
Thank you for your kind words!
Great , thank you so much ❤
Thank you! We are thrilled to hear that!
Wow!!! Thank you
Glad to hear that. Thank you for your comment!
Amazing!! To the point
Thank you!
Sweet... I've been looking for this. Thanks..
Enjoy it:)
Thank you ❤
We are glad to hear that you like it!
Wao it was amazing
Thank you! We are glad to hear that!
Thanks
Thank you 👍😊
More than welcome :)
Hello, thankyou for the video. Can you tell how to show %completion status in this?
Hi there, you can add completion % with Conditional Formatting > Data Bars in Excel. First, write your completion percentages and then add conditional formatting for a visual representation. Hope this helps! You can visit our Conditional Formatting Guideline for advanced tricks: www.someka.net/blog/excel-conditional-formatting/
When I select dates, they don't appear the way I want them, my dates starts from 2023 but in the chart it appears from 1900, how do I change it?
Hey there! Please ensure that your data is formatted correctly. Select your input date data, right click, and choose Format Cells. Under Category, select Date and your preferred date format. Hope this works for you.
How to remove gaps between the dates
Hi there! If you want to remove the gaps between the orange bars, select them by right-clicking on them and choose "Format Data Series" on the menu. Then, go to Series Options on the side bar and decrease the Gap Width to 0% and increase the Series Overlap to 100%. This will remove the gaps between orange bars.
However, if you want to adjust the intervals of horizantal axis (date intervals), you can right click the dates > Format Axis > Units and you can write how many days you want the intervals to be on the Major box.
Hope these answers help! If you need further assistance, you can also contact us via contact @ someka . net
But how about to make a duration in the same date
only differences is time?
Ex. Startdate: 1/1/2022 1pm
Enddate: 1/1/2022 5pm
hi there, we're using chart method here, and the dates are only the axes data of this chart. So if you use timings (which excel also let you do), then your chart will be formed based on the timings, not the dates. Hope this helps! For other methods to make Gantt in Excel and more detailed information, please visit our article: www.someka.net/blog/how-to-make-gantt-chart-in-excel/
thank you
Précise . Thank you
Glad it was helpful!
Thank You👍
You are welcome @akashravat7439!
Can you help me? I wasn't able to follow what you typed in "series name" and "series values".
Thank you for reaching. You can use Start Dates and Duration as series in this chart. But here's a complete guide of this tutorial: www.someka.net/blog/how-to-make-gantt-chart-in-excel/
Hope this helps!
Thankyou so much
Most welcome 😊
Can I use for different years?
Yes, you can enter any date you need.
Hi I want the date axis to start with the given date and not something random, how can I adjust these dates on axis, it is automatically predating couple of months
Hi Sundeep, you can try giving 0 to the start date of the first task and then manipulating the start dates of other tasks accordingly. But this will need of course some workarounds on the data. Because this is a very basic way to create gantts. If you need a more professional solution, please try our Gantt Chart Template: www.someka.net/products/gantt-chart-excel-template/
Thanks again for your comment.
Hello, I have a problem when I do the Gantt chart. The task I listed in the table was not all shown in the Gantt chart. Any ideas how to solve it?
Hi there, there's chance your file is on manual calculation mode, instead of auto-calculation. Or there might be some jumps on the formula. Maybe you can just send us your file at contact@someka.net, and we can check it out. By the way, also do not forget to check our ready-made gantt chart templates: www.someka.net/products/gantt-chart-excel-template/
But I dont want to see sunday days because I dont work sunday. What should I do for duration box. I should write new formul in duration box. But What ?
Hi there, thank you for asking. You can use the WEEKDAY function to check if start or end date of your tasks is a sunday or not and then increase the number of duration if any of them includes a sunday. Hope this helps! But if you're looking for a more complex gantt, you can try our product: www.someka.net/products/gantt-chart-excel-template/
This template has a settings part where you can exclude any weekday from your gantt automatically. Thank you!
Hi, do you have any video where suppose i have fix set of activities to be performed.
Each activity may be sub activities.
Like if 1 st activity has 1000 sub activities we say that 500 is complete. The we show status showing 50% is completed.
Next week if we complete 250 out of remaining 500. So status updates to 75% complete?
What i can use for that ?
Hi there, thank you very much for your question.
Actually we do have an Action Plan Excel Template, designed to track the progress of many actions under specific goals. We think this might be highly interest you. You can just have a look and download free version to test it out:
www.someka.net/products/action-plan-excel-template/
Thank you!
Is it possible to do this in power bi?
Hi, this method is actually an workaround on the simple bar charts. So you can use the same logic on any other platforms, which may include the power Bı or other spreadsheet software. This is an Excel exemple, and include the excel chart features. Thank you!
Cheers bud
Cheers!
The dates are coming wrongly
How did you make that orange label in bar chart
Hello, once you insert the chart, right-click on the chart>click Select data>click Add and add duration cells to series name and duration values to series values. The orange label will appear.
@@SomekaNet Thank you 💗
Great!!!
Can you tell me this apps name
Hi there, this is a tutorial video to build gantt charts in excel. If you're looking for a ready-to-use tool, just check our Someka Gantt Chart Maker: www.someka.net/products/gantt-chart-excel-template/
Hope this helps!
Well, all videos on TH-cam do the same as you do, i.e. create the chart first and add "Duration" later. I wonder why don't you select two data columns at the beginning and create the chart at one go. As simple as that.
Hello, thank you for your question. If you select both start time and duration at the same time and insert the chart, it won't create the Gantt chart properly and won't create the orange areas on the bars.
@@SomekaNet It works that way. But I like how you create flow chart in excel in another video. I haven't tried it yet, but it looks great. Thanks.
Useless to me. Sorry
Thank you for your comment. If there's a particular reason for that, we'd like to hear. Please reach us contact@someka.net for any questions.
Thank you 😍
You're welcome 😊