How to Create a Gantt Chart in Excel
I like Excel. I use it daily. In companies and homes all over the world, people use Excel for everything – from a makeshift calculator to tracking massive projects. Given the software's omnipresence, it’s no wonder so many people try to repurpose it for tasks that Excel was never meant to do.
To demonstrate, I created this How to Create a Gantt chart in Excel tutorial. I'll show you how to create an Excel Gantt chart, then I'll demonstrate how the Smartsheet online Gantt chart software makes this far easier.
Real time Gantt charts in the cloud. Take a free test drive on us!
What Is a Gantt chart?
Gantt charts make it easy to visualize project management timelines by transforming task names, start dates, durations, and end dates into cascading horizontal bar charts.
An Excel Gantt chart
How to Create a Gantt chart in Excel
1. Create a Task Table
List each task in your project in start date order from beginning to end. Include the task name, start date, duration, and end date.
Make your list as complete as possible. Because of Excel's limitations, adding steps or extending out may force you to reformat your entire chart.
2. Build a Bar Chart
On the top menu, select Insert, and then click on the Bar chart icon. When the drop-down menu appears, choose the flat Stacked Bar Chart, highlighted in yellow below. This will insert a blank chart onto your spreadsheet.
Add Start Date data.
Next, add the Durations column using the same procedure you used to add the start dates.
Change the dates on the left side of the chart into a list of tasks.
Your Gantt chart ought to look like this:
3. Format Your Gantt chart
What you have is a stacked bar chart. The starting dates are blue and the durations are red.
Notice your tasks are in reverse order. To fix this, click on the list of tasks to select them, then right click over the list and choose Format Axis. Select the checkbox Categories in reverse order and Close.
To give your Gantt chart more space delete the Start Date, Duration legend on the right. Select it with your mouse, then hit delete.
Hide the blue portions of each bar. Clicking on the blue part of any bar will select all of them. Then, right click and choose Format Data Series.
You're almost finished. You just need to remove the empty white space at the start of your Gantt chart:
If you want to make your Gantt chart look a little nicer, remove most of the white space between the bars.
You are finished. Your Gantt chart should look like this:
This is a lot to remember.
While your Excel Gantt chart may look clean, it is not exactly serviceable.
It is possible to create more complete Gantt charts in Excel, however, they are more complicated to setup and maintain. The things that make Gantt charts useful, sharable, and collaborative cannot be accomplished with Excel.
In Smartsheet, to make a Gantt chart:
Smartsheet will prompt you to name your sheet with the Gantt chart. From there, you're good to go. You can start entering your task list.
Add task names for each task, two of either the start date, duration, or end date. When you enter two of these, Smartsheet populates the rest. From here, when you change any of the three variables, the other two will automatically recalculate.
The other thing Smartsheet adds automatically are your horizontal bars. Unlike in Excel, there is no need to format anything. Smartsheet does it for you.
Another well-designed feature, when you use your mouse to click and drag either end of any green bar, Smartsheet changes the matching dates and durations in the task table. From here you can add additional Gantt data such as predecessors and task groups.
You can even switch to Smartsheet's calendar view.
Already your simple Smartsheet is far more functional and responsive than an Excel Gantt chart, and you're just getting started. Watch our video to learn even more.
See for yourself. If you don't own a Smartsheet account, try one on us. Get a free 30 day trial with nothing to install.