Gantt Chart in Excel | 60 Seconds Tutorial

[@aishasadiq1017]

straight to the point. thank you

[@SomekaNet]

Most welcome :)

[@teresaanthony9633]

@@SomekaNet this is amazing how can do this quarterly wise?

[@SomekaNet]

@@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!

[@kartik_jha__01]

Great❤

[@SomekaNet]

Thank you! 😊

[@safiaguellil3660]

Thank you very much! Very useful!

[@SomekaNet]

We are glad to hear that :)

[@ebonyegreen8643]

Very useful. Saved my assignment

[@SomekaNet]

Thank you! We're so happy to hear that!

[@innyn5247]

Thanks so much, short to the point and helpful

[@SomekaNet]

Thank you for your kind words!

[@asri6592]

Thank you. It's very helpful

[@SomekaNet]

Glad it was helpful!

[@MattExo-Dynamics]

Great video! i was losing my will to live working out how to do this

[@SomekaNet]

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.

[@iodize1984]

Sweet... I've been looking for this. Thanks..

[@SomekaNet]

Enjoy it:)

[@i_am_RB]

Amazing!! To the point

[@SomekaNet]

Thank you!

[@NSq12]

Thank you so much

[@home4475]

Great , thank you so much ❤

[@SomekaNet]

Thank you! We are thrilled to hear that!

[@xtina1011]

How do you fix the dates at the top of the chart? They're jumbled

[@SomekaNet]

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!

[@complicated_generation]

Awesome!!!😊

[@SomekaNet]

Thank you :)

[@tpmash]

Wow!!! Thank you

[@SomekaNet]

Glad to hear that. Thank you for your comment!

[@jeyrubini]

Thank you ❤

[@SomekaNet]

We are glad to hear that you like it!

[@vissshal]

Thanks

[@kunalaggarwal3551]

Wao it was amazing

[@SomekaNet]

Thank you! We are glad to hear that!

[@ChathraWijesinghe]

Thank you 👍😊

[@SomekaNet]

More than welcome :)

[@abhijitshukla5320]

Hello, thankyou for the video. Can you tell how to show %completion status in this?

[@SomekaNet]

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/

[@jyothiyedida5845]

Précise . Thank you

[@SomekaNet]

Glad it was helpful!

[@NSM1985]

How to remove gaps between the dates

[@SomekaNet]

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

[@Ilhemworld]

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?

[@SomekaNet]

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.

[@akashravat7439]

Thank You👍

[@SomekaNet]

You are welcome @akashravat7439!

[@genzo387]

Can I use for different years?

[@SomekaNet]

Yes, you can enter any date you need.

[@martinlouisvillanueva5708]

Can you help me? I wasn't able to follow what you typed in "series name" and "series values".

[@SomekaNet]

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!

[@mmwh5100]

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?

[@SomekaNet]

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 [e-mail], 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/

[@sundeep9071]

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

[@SomekaNet]

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.

[@sas546]

Thankyou so much

[@SomekaNet]

Most welcome 😊

[@chizzy_18]

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

[@SomekaNet]

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/

[@chizzy_18]

thank you

[@fatihgunan5605]

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 ?

[@SomekaNet]

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!

[@JhaAkshit]

Cheers bud

[@SomekaNet]

Cheers!

[@saurabhshrigadi]

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 ?

[@SomekaNet]

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!

[@anjalignair6590]

The dates are coming wrongly

[@Hasna1919]

Is it possible to do this in power bi?

[@SomekaNet]

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!

[@sranjan69]

How did you make that orange label in bar chart

[@SomekaNet]

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.

[@sranjan69]

@@SomekaNet Thank you 💗

[@kosarmojabi6316]

Great!!!

[@alihasans_hobbi]

Can you tell me this apps name

[@SomekaNet]

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!

[@ninhful]

Well, all videos on KZbin 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.

[@SomekaNet]

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.

[@ninhful]

@@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.

[@Chinchuchinn]

Thank you 😍

[@SomekaNet]

You're welcome 😊