How to Make a Gantt Chart Using Excel

Adriana Girdler

Step-by-step tutorial for total beginners! So, you need to make a Gantt chart that’s fast and easy but you have ZERO experience doing it. Where …

Step-by-step tutorial for total beginners!

So, you need to make a Gantt chart that’s fast and easy but you have ZERO experience doing it. Where do you even begin?

It might sound overwhelming, but it’s actually quite easy. Let’s dive into a simple step-by-step way to do it.

Start with the basics

The first thing you need to do when it comes to making a Gantt chart in Excel is to get all your information down.

Make a column to write all your action items, and then subsequent columns for your start date, end date, and the duration of each item.

This is your really basic information and starting point that you need to create the Gantt chart.

Create the chart

Next, you’ll want to get the chart set up by adding the bar chart feature to your Excel page.

I wish I could explain how to do all that right here, but the truth is it’s a lot easier to just show you (and it will be a lot easier for you to follow when you see it visually).

So, let’s head over to YouTube so that I can actually SHOW you the whole step-by-step process!

Meanwhile, if you really are committed to mastering your next project, do consider taking my SLAY Project Management online course where I show you step-by-step how to successfully manage a project, plus you get access to every template you will need, along with detailed video instructions on how to fill them out.


Thanks For Sharing!

Photo of author

Adriana Girdler is a project manager, productivity specialist, entrepreneur, professional speaker, facilitator, visioning wizard, and author. As President of CornerStone Dynamics, Adriana is one of Canada’s prominent business productivity and project management specialists—helping both individuals and businesses do what they do, only better. She is a certified master black belt lean six sigma with over 20 years’ experience improving how companies work.

She also holds both PMP (project management professional) and CET (certified engineering technologist) designations. She’s a Tedx speaker, as well as a HuffPost and Thrive Global contributor. She has been interviewed on Global, CBC, CTV, CHCH, 680News Radio, Newstalk 1010, Sirius XM and published in the Globe and Mail and numerous industry magazines. WANT ADRIANA'S FREE ONLINE TRAINING? In 45 min, learn Adriana's 5 project management secrets she use on EVERY project. Sign up for the Free Webinar here: THE FAB FIVE FUNDAMENTALS OF PROJECT MANAGEMENT

SLAY Project Management

Online Course

5 Sections and 24 step-by-step HOW TO Videos! The only 5-hour on-line course that teaches you the PRACTICAL side of project management. This course will guide you step-by-step on HOW to successfully run a project and provides you with all the templates and tips you need to be successful.

Fab 5 Fundamentals

Free Training

Are you striving for successful projects, but get overwhelmed figuring out what elements of project management to focus on for the best results? In the Fab Five Fundamentals of Project Management, you’ll learn the five things you need to do on EVERY project to bring it to success.

Why Projects Fail?

Free Download

If you're new to projects or need a refresher, here's a guide of all the things I learned during my journey. Project success is about knowing how to navigate and stay clear of roadblocks, issues and problems. Understand the top 10 reasons why projects fail and how to avoid them.

Interested In Working Together?

We are business productivity experts. Contact us to learn how we can help your business become more efficient and increase profitability.

Join Our Newsletter

Join over 50,000 subscribers. Get the latest and the best in project management information delivered straight to your inbox.

Follow Us