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

Britney Spears - Criminal (Lyric Video)
BritneySpearsVEVO
SENAM GURU & ANAK CINTA INDONESIA 2017
ADIVA CHANEL
Muskuraataa Huaa Gul | Kishore Kumar | Shabana Azmi | Vinod Khanna
MovieTeeVeeHindi
My redeemer lives - Lyrics
Stherr15
How To: Barbell Stepping Lunge
ScottHermanFitness
[BANGTAN BOMB] Pretty Age 25 (turn up!)
BANGTANTV
Maff Boothroyd - Still Believe (ft. Taylor William)
ChillYourMind
Power Rangers Zeo Lost Prologue Mini-Episode pt1.
Xeric2007
سیب میخورم.......😂😂😂😂😂😂
Amirhossein Mma
Vandal caught on camera
MyNorthwest
러블리즈 (Lovelyz) - WoW! MV
Stone Music Entertainment
Let's Dance(렛츠댄스): (G)I-DLE((여자)아이들) _ JEON SO YEON(소연 직캠ver)
1theK (원더케이)
How to Do the Au | Capoeira
Howcast
Journey - Don't Stop Believin' (Live in Houston)
journeyVEVO
amv Mix Action 13
AMVs J.I.C
Что воля что неволя всё равно
Василий Вереск
Tekno miles - Where
TeknoMilesVEVO
☆大阪オートメッセ 2018☆ NGK 山下春菜 さん ☆4K コンパニオン☆
Girl Beauty Secrets
Distruction Boyz at a wedding
Thabo Matsoalela
Introducing DNAscan Rapid DNA Analysis System
National DNA Database
Adriane Galisteu mete o nariz nos homens do Porchat
Programa do Porchat
Get Smart - "Missed It By THAT Much!"
wjteegarden
Apink and bts fmv by marlena malec
Julia Sak
The Daily Caller Misgenders Blaire White
Hi, I Think I'm Real
[fancam]171111 세븐틴(SEVENTEEN) 누리꿈 팬싸 모자를 눌러 쓰고 Without You 준 JUN focus
moonjerry
Peter Rabbit's Christmas Tale
Happy Kids Club
[STATION] SMTOWN 'Dear My Family (Live Concert Ver.)' MV
SMTOWN
Alia Bhatt in Bikini ( Super Slow Motion )
PRO vertz
Coway Technology Air Purifier System
cowayusa
La pócima de liberación | Tic Tac - T1E53
Teleseries y series | TVN
The Beatles-Here comes the Sun.
La Banda Sonora de mi vida-INCITATUS
Silent Hill - Not Tomorrow (Hip-Hop Instrumental Version)
Maxentius Music
Lav kush singing in ll Ram Rajsabha ll
Aditya Mobile Shop
CNN 2016 Election Night Coverage (Stutter Free Copy) Part 01
31 Mike
How to Do the Macaco | Capoeira
Howcast
12 Coisas Que Suas Fezes Dizem Sobre Sua Saúde
INCRÍVEL
Vingadores 2 filme completo dublado
Evanskyn○11
THE SOLO SURVIVOR - Escape From Tarkov
OperatorDrewski
Q / 조용필
nishinago
lifestyle 20110531
karina orlova
Zyn Zyn Zyn, Зын Зын Зын
TOKENOV
Les premières philosophies en Grèce - Séance 8 - par Annick Stevens - Théâtre...
Université Populaire de Marseille
'The Siblings Are Ready' Mental Prep | Fear Factor Hosted by Ludacris | MTV
MTV
Indonesia Bagus - Taman Nasional Meru Betiri, Banyuwangi
Netmediatama
OPERA FLASH MOB 'Verdi Style'
Jonathan Estabrooks
오하영 뻔뻔함
보수롱
Ringling Bros. Presents Circus XTREME
Ringling Bros. and Barnum & Bailey Circus
170826 EXO (엑소) - Monster (몬스터) @ M-ON a-nation 2017
TNK
Sabse Badhkar Hum 3 (Chinnadana Nee Kosam) 2018 New Released Full Hindi Dubbed Movie | Nithin
Goldmines Telefilms
仮面ライダーフォーゼ THE MOVIE みんなで宇宙キターッ!(予告編)
toeimovies
Apple Pay — How to pay with Face ID on iPhone X— Apple
Apple
ก้มเห็นจุก
pe1 playboy
Stone cold steve austin drinks beer
Expacio Ninja
[BANGTAN BOMB] Jimin self cam with A.R.M.Y
BANGTANTV
Reagan's Raiders #1 - Atop the Fourth Wall
Linkara-AtopTheFourthWall
NEW DIET SYSTEM FOUNDER B.V.CHAUHAN SAHEB BY GRAPES SHIBIR-1 DAY/PART-1
SWADARSHAN SADHANA KENDRA NEW DIET SYSTEM
Uma mulher começou a cantar 'Evidências' no metrô de São Paulo e não teve um que...
Sociedade Dos Poetas Subversivos
POLITY TOP 40 MCQ: MOST IMPORTANT
Aim with Rakesh
Joy Division - Love Will Tear Us Apart (best audio)
Golden Eighties
【课时01】ACE 走遍美国学口语1 第1集第1讲
Hanhan Zhang
Lil Mama & A Champ Go Head To Head | The Sneak Peek Show | MTV
MTV
170116 아육대 마지막 방탄 퇴장 풀버젼
KONI MIRE
10 Substances That Defy The Laws of Physics
Facts Verse
How to Do the Martelo | Capoeira
Howcast
Brasil 3x0 Estados Unidos - Copa das Confederações 2009 - Gol Robinho
Eufilpe
Puppet Hypnosis
Princess Fae
TransAngels Chanel Santini & Kimberlee | Cocked Behind Bars
TransAngels
Sol en Escorpio
almacultura. com
读《山海经》才知道,夸父追的不是太阳,而是它!
銀霧影社
Giant Galapagos Tortoise Collapses into Shell
ok2bconfused
~夏の思い出~ 東京ソフィア女声合唱団
童謡・唱歌 : 春夏編
Um messias Indeciso (Raul Seixas)
Gerdal Maluco Beleza
[KY 금영노래방] 신유 - 잠자는 공주 (KY Karaoke No.KY85924)
KY Karaoke
Columbia Pictures Intro
Kailash R
ሪዝቅ || በአቡበከር ይርጋ
ethio sani tube
Paisagens em movimento
National Geographic Portugal
Geführte Meditation gegen Kopfschmerzen
Fengshuimeisterei
Bagaimana Cara Beribadah Agar Diterima di Sisi Allah (Ustadz Dr Syafiq Riza Basalamah, MA)
Hanya Ceramah
niddong's daily make up 니똥의 데일리 메이크업
니똥niddong
twiddy - Live from the Bowling Alley
Majestic Casual
The Skill of Humor | Andrew Tarvin | TEDxTAMU
TEDx Talks
Best of OldSchool Music 💠 Hands Up 💠 Techno 💠 Trance 💠 Hardstyle 💠 Best Music Mix 2018
Best Music 4Ever
¿Qué planea Johnny? | Tic Tac -T1E54
Teleseries y series | TVN
Justin Bieber - Love Yourself Lyrics
Mrs Downey
أجمل أنشودة عن وداع وفقدان الأم .. ودعتني وأوجعتني .!!
Marwan Sabah
AVISO IIMPORTANTE!!! MADHUNTER CAZANDO SONRISAS JUGUETES
Madhunter Juguetes Antiguos
How to Do the Bancao | Capoeira
Howcast
»♥« musica instrumental relajante»♥«
CHIK0TEMID0
SUPER GEOMETRY DASH BROS. 2.0 [DOPE ASS LEVELS!!]
DashieGames
Chip ti mẹ
anh tuan
The Boss Baby Official Trailer - Teaser (2017) - Alec Baldwin Movie
Movieclips Trailers
朴树2015新专辑《好好地》同名歌曲MV
Jay Young
SAHARA - Jasmine Walia | New romantic what's app status
Mr. What's App
Hackers Charging Fortnite Players Cards, Overwatch Pro Dismissed, Nintendo Switch 5 0 Update
ProtoMario
The Best of Heather & Miles - January 2, 2013
UCB The Cagematch
コブクロ つぼみ
桑畑ぽん助
Telugu TV Anchor Hot Moments ...
SJR TELUGU
Via Vallen feat. Pendhoza - Aku Cah Kerjo [OFFICIAL] #music #vyanisty
MEGA RECORD
metallica nothing else matters sub español
Mijael Cabrera
Waking Up With Sam Harris #49 - The Lesser Evil (with Andrew Sullivan)
Sam Harris
Cara Beli tiket kereta di traveloka | Tutorial
jefri sasongko
Bé gái 14 tuổi vén áo uốn éo trên bigo live
giải trí vui
Лопаем Шарики с Водой и Купаемся в Джакузи! Big Water Balloons
Ksu Lite
Post Malone Feat. Nicky Jam & Ozuna - rockstar Latin remix
Post Malone
iggy azalea, monster ces18
E Holly
WILLY WILLIAM - Te Quiero (Official Video)
Ego Italy
Cardi B - Be Careful [Official Video]
Cardi B
Cele Mai Controversate Teorii Ale Conspiratiei (Teorii Incredibile)
Teorii Incredibile Oficial
MAN WITH A MISSION - Take Me Under
MWAMVEVO
大川小校舎内映像
KAHOKUSHIMPO
Amy Winehouse, Valerie and lyrics
songsandlyricsforyou
Bring Me The Horizon - Home Sweet Hole Lyric Video
The Music Cat
「エジプトの目が開かれる!」Unity in Egypt
Lehigh Valley Japanese Ministries
The Girl Teaches The Bully A Lesson In The Ring
John Bosco
AIM GLOBAL Coaching #1: Paano mag one on one presentation (Part 1)
Maria Theresa Gonzales
kajal Agarwal patani wardrobe slowmotion
Slowmotion Central TM
Victoria confesó su crimen | Tic Tac - T1E52
Teleseries y series | TVN
Mãe - Marcos Antonio / Especial Dia das Mães
PlayList Gospel
【公式】ドラマ「パパ活」第1話(脚本:野島伸司)《100万回再生突破!!!》
dTV
Power Rangers Ninja Steel - Official Ninja Steel Trailer | Power Morphicon 2016 Teaser
Neo-Saban Power Rangers