SITES ABOUT
Select your download option
mp4 Files
144p
256x144
240p
426x238
360p
640x360
480p
854x480
720p
1280x718
medium
640x360
hd720
1280x718
m4a Files
DASH audio
webm Files
DASH audio
DASH audio
DASH audio
DASH audio
144p
256x144
240p
426x238
360p
640x360
480p
854x480
720p
1280x718
medium
640x360
3gp Files
small
176x144
small
320x180
Excel Gantt Chart Tutorial - How to Make a Gantt Chart in Microsoft Excel 2013 Excel 2010 Excel 2007
VideoDefinition
Details
Share

Gantt Chart Tutorial in Microsoft Excel 2013
Excel Gantt Chart Tutorial
Gantt Chart Tutorial
How to Make a Gantt Chart

In this tutorial we will show you how to create a Gantt Chart using Excel. Excel doesn't actually have a default Gantt Chart, therefore we will modify a bar chart to turn it into a Gantt Chart.

Step 1: First we need to enter our data such as the tasks, the start date, days completed and days remaining. See the image below and enter your data exactly as shown in the image.



how to create a gantt chart in Microsoft Excel


We did not enter an end date because the days completed and days remaining provide the end date through simple arithmetic.

Step 2: After entering your data into the cells, you can start building your Gantt Chart.
1.Click the insert tab on the ribbon.
2.Now select the bar Bar Chart command in the Charts group and select the Stacked Bar Chart as shown in the image below.

After you have clicked on the stacked sideways bar chart a blank chart should show up.


how to create a gantt chart using Microsoft Excel


Step 3: Right click on the blank chart and select data.


gantt chart excel


The Select Data Series dialog will appear. Click Add Series and the Edit Series dialog box will appear. In the Series Name box name this series "Start Date" and for Series Value select all the dates listed under Start Date in your Excel Sheet. Then click OK! See the image below.


gantt chart excel tutorial


Step 4: After clicking OK in the Start Date Series box the Select Data Source" box will appear again.

Click Edit under the Horizontal (Category) Axis Label and the Axis Label box will appear. In this box you will enter the tasks. To do this simply select inside the box, then press control and select all the tasks in the Excel Sheet. See the image below for assistance.


excel tutorial gantt chart


Excel Tutorial How to Create a Gantt Chart
Step 5: Right click on the chart again. Select Data and add a new series. This time you will add the "days completed" to the chart. You will do the same thing you did for the start date. Enter "Days completed" in the Series Name and select all the cells (even the cell without content) listed under Days Complete. See Below.


how to create a Gantt Chart in Excel


Step 6: Now we will add another series to the chart for the Days Remaining column the same way we did the Start Date Series and the Days Completed Series. Step 7: In this step we will hide the Start Date Bars because they are not needed for visual purposes in our Gantt Chart. To do this: 1.Right click on the Start Date bars and select Format Data Series in the shortcut menu.
2.The Format Data Series dialog box will appear. In this box click on the Fill tab and the click the No Fill button & press OK


how to create a gantt chart in Excel


Step 8: Two problems should be obvious. Our tasks are in reverse order and there is a gap showing dates before the project's start date that we don't need.

First let's get our task in the correct order! 1.Right click the task on the chart and click format axis. Then you should see Axis Options here you will select the categories in reverse order box.


excel for noobs


Step 9: Now that our tasks are in the correct order, we need to remove the gap before the official start date. To do this you must understand how Excel recognizes dates.

1. Copy the earliest date under the start date part of your sheet and paste it into another cell off to the right. See below.


excel for noobs gantt chart tutorial


2.Now change the number format to general and take note of that number.


3. Now right click on the dates, in the axis options click on "Minimum Fized and enter the number that the earliest date was converted to.

We now have a complete Gantt Chart. We can update the days completed and remaining and the Gantt Chart will automatically correct itself.

More From YouTube

[방탄소년단] 달달한 최강리얼 브로맨스 이야기
섹시스트리
THE SOUND OF SILENCE: Fingerstyle Guitar Cover + TAB by GuitarNick
TheGuitarNick
How To Cook Dominican Oxtails With My Momma!!
MonicaStyle Muse
Saad Lamjarred - CASABLANCA (EXCLUSIVE Music Video) | (فيديو كليب حصري) CASABLANCA...
Saad Lamjarred | سعد لمجرد
Principles of mobile app design: Delight users and drive conversions - Google I/O 2016
Google Developers
SAUL COBA-2015- SE QUE MIA SERAS
javier william quispe yupanqui
Michael Sembello - Maniac (1983)
clips4you
|ARD Aktuell tagesschau Melodie ohne Sprecher! [2014]
Güldner TV
Best Fight Scenes: Chin Siu-Ho
Jamyang Pelsang
Time Slime (Bravest Warriors - Ep. 1 Season 1)
BravestWarriors
Gudejat NA Dany & Katia (06/20/14)
Yordan Mandov
So ERHÖHST Du Dein EINKOMMEN | Bis zu 300% durch Positionierung
Bodo Schäfer
PAQUES 2017 - JIMMY KIBANGU
Henri Papa Mulaja
Girl Meets World S03E08 - Riley and Lucas almost kiss
Girl Meets Youtube
BLENDER Tutorial: Creating Grass in Blender
CALIBERBEATS
DJ Black ft. General Steel - Ready For Party [Official Lyric Video] HD
djblack germany
161116 Asia Artist Awards(AAA) 방탄소년단(BTS) - 불타오르네 직캠
L J
Disturbed - The Evolution of The Guy
Disturbed
Four Of Diamonds - Name On It (Official Video) ft. Burna Boy
FourOfDiamondsVEVO
3 HORAS DE VIDEO MOTIVACIONAL - Assista, Ouça, Reflita - AUTO AJUDA Motivação
Nando Pinheiro
PJ Masks Superpigiamini Episodi Completi 3 + 4 | Nuovi Episodi | Cartoni Animati
PJ Masks Superpigiamini - Canale Ufficiale
2018 YDS İngilizce Dersi Tanıtım Videosu
Benim Hocam
Anabel Angus 2018 Jul 23
Hopeless LegMan
Underworld Fanboys Step Into Kate Beckinsale's Iconic Suit | 'Underworld: Blood...
MTV
CREATE AN EPROXY CONFIG IN JUST A FEW MINUTES [100% WORKING]
ANNONYMUS KRUGER GAMING INC.
Ana Roxana Us Gomez Un año mas
JORDAN PRODUCCIONES
M.O.V.E. (Make Our Voice Echo) - i'M (Ligaya by Gouryella - i'M Mix) [Promotion]
jjinnylee
Missile Nord Corea 15/09/2017 Situazione - Vivi Giappone
Vivi Giappone - video sul Giappone dal Giappone!
Slaves, 1969
Jon Williams
Top 10 All Turn auditions The voice USA
ShowMe
Power Rangers Hexagon Season 8 Promo 2
SentaiFive OFFICIAL
НЕДОШОППИНГ С МАШЕЙ
V. Viktoria
MUSIC GRADE 9 1ST QUARTER
Lucky Fonte
Asdfmovie 10 - Chase me Susie !
Arno P.
[서폿후기] 러블리즈(Lovelyz) 정예인 생일축하 전광판 인증영상
연습생닷컴/YSSCOM
Zouhair Bahaoui - DÉCAPOTABLE (EXCLUSIVE Music Video) | (زهير البهاوي - دكابوطابل...
Zouhair Bahaoui | زهير بهاوي
Britney Spears - Criminal (Lyric Video)
BritneySpearsVEVO
Cristiano Araújo - Efeitos (Oficial)
Cristiano Araújo
WENDY'S MUKBANG!!! (CHICKEN NUGGETS, FRIES & MORE!)
Kennedy Cymone
Alexandra Daddario at Rampage Los Angeles film premiere
Access Video TV
JFK - Assassination : Oswald's Ghost ( 2007 )
JFK Assassination History
Tremendo e insensible exabrupto de Macri: "Para arreglar los problemitas, o un escape de gas"
Revolución Popular Noticias
V6 / Remember your love
avex
Liaise with Other Staff
TESDA Online Program
SEAFOOD BOIL FAMILY (MUKBANG)
Taylor Girlz VLOGS
Apresentação Garoto e Garota CEMA - Equipe Os Incríveis - Gincana CEMA 2011
darth2000
Noize Mc - Вселенная бесконечная Караоке
Караоке канал KARAOKE - AD*
Best Fight Scenes: Vincent Zhao
Jamyang Pelsang
Bunifu UI .Net Framework Tutorial 1
Bunifu Technologies
PRO D2 - Résumé Nevers-Biarritz: 26-12 - J21 - Saison 2017/2018
PRO D2 - Officiel
SUMMER | DOLOMITES 8K TIMELAPSE
Timestorm Films
Deal With It Glasses Green Screen Source MLG
Diablo666
Netsky Live at Ultra Music Festival, Miami 2015
Netsky
Infomercialism: Ultimate Chopper
Mike Jeavons
See what She did when She knew He has $5 Million!
ComedyOn
You Made It Weird with Bill Burr
Logan HighestPrimate
Scorpions - Wind of Change
Ozielzinho
NoLove Fight Week Ep1 - UFC227 The Arrival - Behind the scene footage!
Cody NoLoveTV
N2N Bodywear 2017 Campaign ft. Igor Kolomiyets
Male Model Corp
[NCT LIFE MINI] NCT 127 ‘Angel’ (‘LIMITLESS’ Cafe Ver.)
SMTOWN
SAO Abridged Parody: Episode 03
Something Witty Entertainment
Dançando funk(MC WM)
Brincando e Aprendendo
SA House Music Mix (Remember the days) 06 Nov 2017 @UWC by KingMasbi
MASIBULELE SOMKOKO
WE WENT PAINTBALL SHOOTING FOR TI DAY
Taylor Girlz VLOGS
Pamela Alexandra I'm actually shy in real life
ART NEWS
Tye's Booty
tNraFmse
أغنية يا ليلي ويا ليلة مع ديسباسيتو || Ya Lili + Despacito (🔥Official Video🔥)
Noor Radwan نور رضوان
Mad Summer (Kikujiro Soundtrack)
Soundtrackization
141110 구로 팬사인회 │ 방탄소년단, 뷔(V)
TAETAE LAND
Air - Love 2 (FULL ALBUM)
airofficial
GT-1 Quick Start chapter6 : Setting for CTL1 Pedal
BOSSchannel
Developing the Basics- Bar Stations
DeAvera Todd
Can 20,000 Magnets Catch A Bullet Mid Air?
MrBeast
Ocho (Remix) Almighty Ft Noriel, Bryant Myers, Ñengo Flow, Pusho, Kendo, Randy...
UrbanoVideosTV
TESTIMONIO JESUCRISTO ENTRA A CELDA DE JOSMAR FLORES (PARTE 2)
jose luis avila aguilar
VISHU ASAMSAKAL
SHIJI VEMBAYAM
Josh. - Cordula Grün (offizielles Video)
Josh.
Most Popular Kirtan | Mix Ragi | Non Stop Kirtan | Shabad Gurbani | Bhinni Rehnariye...
Babli Singh
Baki (2018)「AMV」- Fight Like The Devil
Slayer AMV 夢
HOW TO LOOK YOUNGER! Revamping My Mom's Makeup Routine! (+ GIVEAWAY!)
Alissa Ashley
TROQUEI ELA PELO FORTNITE (FICOU PISTOLA ??) ‹ JonVlogs ›
Jon Vlogs
14 ANNOYING Things About BOOBS
DontTrustTheRabbit
Western Movies - Raiders of Old California (1957) Cowboy Movies
Massmo
Myo Kyawt Myaing - Min A Twet
Oj Minty Fresh
BrainStorm
David Johnson
Franco de Vita - Cuando Tus Ojos Me Miran (Cover Audio Video)
FrancodeVitaVEVO
When A Man Loves Episode 12: Jae Hee Can't Resist Kissing Mi Do During a Tearful Goodbye
DramaFever
ATOMIC BOMB TOP Compilation HD
Alfredo G
வாணி ராணி - VAANI RANI - Episode 1632 28/7/2018
RadaanMedia
Migos - What The Price [Official Video]
Migos ATL
COUPLEBILDER NACHSTELLEN !! w/ BOYFRIEND
Jo & Co.
Sath nibhana sathiya | Hey gopal krishn karu arti teri | TV Serial whatsapp status video
STAR AND STAR GROUP VIDEOS
Lovren i Vrsaljko konferencija prije utakmice Hrvatska - Rusija (Svjetsko prvenstvo 2018)
El Clásico
प्यार में पागल | Pyaar Mein Pagal | Latest Bhojpuri Song 2017 | Pradeep Pandey...
Venus Regional
WE MADE A BET WITH OUR DAD 😱 *THIS MIGHT KILL US
Taylor Girlz
Hold Me Thrill Me Kiss Me *** Mel Carter
One UnconditionalLove
La Chona Challenge Fail
La Wepa Web
Best Friends Play Tokyo Mirage Sessions ♯FE (Part 07)
Super Best Friends Play
مليونية محمد حسن افراح سلكا النجم فرج عدوية الراعي الرسمي الريس حسانين ابوالسيد
marco masll /Profile/ Original /Official
Ask an Atheist: How can you be moral if you don’t believe in God?
FFRF
The Doors - Love Her Madly 1971 (High Quality)
NoMadU55555
Silver Road - (Gay Short Film)
CanadianJewel
Shanti People - Tandava (Dion X David Garry Club Edit) ( 1080 X 1920 )
psy trance
Power Rangers Ninja Steel - Return of the Prism - Like an Ninja
SabanPRclips
Nightmare on Elm Street 2: Freddy's Revenge: gay edition
Brakett
Staged Centuries Part 1 Fabricated Reality Invented History Phantom Time historical...
AGE OF DISCLOSURE
ALEX STEIN - Tribute (Original Mix)
Aerochrone
Gabi Delgado - Science Fiction Liebe
denial of service
180113 Apink Pink Space - Eyes
Topi0301
FAMOUS DEATH MASKS
THE REAPER FILES
Will Shiba Inu Eat COCONUT? | Taste it Tuesday
Haru the Shiba Inu
Elon Musk. Best Simulation Hypothesis Video. 2017 1080p Quantum, Technology, Reality...
Schizo Qubit
天才てれびくん 25th Anniversary BEST MTK vol.1 2011-2013
三成殿
A Arte da Guerra - Sun Tzu - Audio Livro - VAI MUDAR SUA VIDA
Mestre de Cerimônias em Curitiba
Popurri:Tatuajes/Llorar & Estos Celos/Jose Manuel Figueroa & Julian Figueroa/En...
Ángel Soroa
Bata sinapian ni jesus christ
Viral and Trending
Dante Ross On Label Gigs and Working For Self
Channel Dynamic
Adventure Up High - Hiking the Continental Divide Trail Documentary
Dylan Ivens
百听不厌的经典老歌 ( 100首最红的经典老歌 至今百听不厌 回味无穷 ) [精選台語歌] taiwan oldies song - sad love songs
經典台語歌曲#台語歌
The Agency E3 2009 Trailer HD
38natik