{"id":1950,"date":"2023-04-27T12:21:35","date_gmt":"2023-04-27T12:21:35","guid":{"rendered":"https:\/\/dijitalturk.com\/veysel\/?p=1950"},"modified":"2023-04-27T12:21:35","modified_gmt":"2023-04-27T12:21:35","slug":"excell-gantt-chart","status":"publish","type":"post","link":"https:\/\/dijitalturk.com\/veysel\/excell-gantt-chart\/","title":{"rendered":"Excell Gantt Chart"},"content":{"rendered":"

Many of us keep an Excel for tasks such as tracking effort, task tracking, reporting, project management, etc. Some may have difficulty with the reporting section of this. Here are the steps to create a Gantt Chart in Excel. I am using Excel in English, but you can see the menu locations in the screenshots, and they will be in the same places in the Turkish version.<\/p>\n

<\/p>\n

Scenario<\/strong>:<\/p>\n

We have an Excel with the planned start dates of our tasks and the effort they will take.<\/p>\n

Our project start date is June 8, 2020.<\/p>\n

After performing the operations, we want to obtain the Gantt Chart report below for project tracking.<\/p>\n

\"\"<\/a><\/p>\n

Let’s get started.<\/p>\n

Our Excel table with the names of our tasks, their start dates, and the effort required.<\/p>\n

\"\"<\/a><\/p>\n

From the buttons in the top menu, we add a chart for the Gantt Chart report, as seen in the screenshot below.<\/p>\n

\"\"<\/a><\/p>\n

We right-click on the blank chart that was added and select “Select Data<\/strong>” to define our data.<\/p>\n

\"\"<\/a><\/p>\n

After clicking on “Select Data,” we click the “Add<\/strong>” button on the left side of the menu, as seen in the example below. \"\"<\/a>Here, we will determine the planned start times of the tasks in the project.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

We click the “Add<\/strong>” button on the left side of the menu again. This time, we will select the data regarding how long these tasks will take.<\/p>\n

\"\"<\/a><\/p>\n

We have roughly created our Gantt Chart, now let’s move on to fine-tuning.<\/p>\n

 <\/p>\n

When we right-click on the graph and click “Select Data,” we will edit the automatically filled area on the right side. Let’s click the “Edit<\/strong>” button.<\/p>\n

\"\"<\/a><\/p>\n

We select the task names. These will be visible in the report we will create.<\/p>\n

\"\"<\/a><\/p>\n

You should see the task names on the graph. Now, let’s right-click on the part of the graph that has the task names and click “Format Axis.<\/strong>”<\/p>\n

\"\"<\/a><\/p>\n

We select the “Categories in Reverse Order<\/strong>” checkbox. This way, we will get a more organized and meaningful graph. We are very close to creating our Gantt Chart report.<\/p>\n

\"\"<\/a><\/p>\n

We don’t need the area regarding the planned start time on the graph. Let’s right-click on the blue bar and select “Format Data Series<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

From the menu on the right side, let’s select “no fill.<\/strong>”<\/p>\n

\"\"<\/a><\/p>\n

Everything is fine, but it would be more meaningful to see the graph from the start of the project. Let’s right-click on the date section of the graph and click “Format Axis<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

In the menu you see below, you need to write the Numeric format of the project start time in the “Minimum” value. If you copy the project start date to a different cell and select the format as Numeric, you can see the value. Write the value you see in the “Minimum<\/strong>” section.<\/p>\n

\"\"<\/a><\/p>\n

That’s it. Our Gantt Chart is ready, and you can make design changes by referring to the example below.<\/p>\n

\"\"<\/a><\/p>\n

I hope this was helpful.<\/p>\n

Some links that may be useful to you:<\/p>\n

Microsoft Office<\/a><\/p>\n

Microsoft Office Support<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Many of us keep an Excel for tasks such as tracking effort, task tracking, reporting, project management, etc. Some may […]<\/p>\n","protected":false},"author":1,"featured_media":1416,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[821],"tags":[828,824,826,830],"class_list":["post-1950","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excell","tag-excell-en","tag-gantt-chart","tag-project","tag-report-en"],"uagb_featured_image_src":{"full":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2020\/06\/Excel.png",500,500,false],"thumbnail":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2020\/06\/Excel-150x150.png",150,150,true],"medium":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2020\/06\/Excel-190x190.png",190,190,true],"medium_large":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2020\/06\/Excel.png",500,500,false],"large":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2020\/06\/Excel-380x380.png",380,380,true],"1536x1536":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2020\/06\/Excel.png",500,500,false],"2048x2048":["https:\/\/dijitalturk.com\/veysel\/wp-content\/uploads\/2020\/06\/Excel.png",500,500,false]},"uagb_author_info":{"display_name":"VeYSeL","author_link":"https:\/\/dijitalturk.com\/veysel\/author\/veysel\/"},"uagb_comment_info":0,"uagb_excerpt":"Many of us keep an Excel for tasks such as tracking effort, task tracking, reporting, project management, etc. Some may […]","_links":{"self":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/1950","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/comments?post=1950"}],"version-history":[{"count":0,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/posts\/1950\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/media\/1416"}],"wp:attachment":[{"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/media?parent=1950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/categories?post=1950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dijitalturk.com\/veysel\/wp-json\/wp\/v2\/tags?post=1950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}