How to Create a Gantt Chart in Excel Easily – Tutorial
This article presents how to create a Gantt chart in Excel, in step by step format. The Gantt chart is heavily used in project management. It is often called a horizontal bar chart. The Gantt Chart Template with horizontal lines is one of the most widely used charts that shows the completed activities and tasks of the project.
Gantt chart is the production control tool that was invented by Henry L. Gantt, an American engineer and social scientist, in 1917. Since last few decades, MS Excel has become a vital tool for businesses due to its increasing utility in personal and professional projects. We are discussing MS Excel here because we can create Gantt Chart through this tool. To make you understand the process of creating a Gantt chart in MS Excel, here we come with the step by step instructions.
Step 1: Do the Project Tasks
Jot down your entire project into various stages till you see the Gant Chart template. Now enter the data by making a list of the Start Date, End Date and the time period of each task. (You will find this option in Excel 2007, 2010 and 2013).
Gantt Diagram template
Step 2: Once the Gantt Chart is on, Start Setting it up to the Stacked Bar Chart
- Click on any blank cell on the same worksheet
- From the Excel Ribbon, select Insert tab
- Select the Bar Chart from the drop-down menu
- Click Stacked bar. This will insert a big black white chart in the worksheet. Avoid selecting 100% of this Stacked bar.
Gantt Chart template
Step 3: Enter The Data On Your Gantt Chart
- On the white chart space, right-click and select your data. It will show the data source window of the Excel sheet.
At the left side of the window, you will see Legend Entries. Click Add and you see the Edit Series window where you can add your data to Gant Chart template sample.
For Adding Data:
Name data (series) by clicking in the empty space (under the Series Name). Click on column header that has Start Date in a table.
Now move to the next step; Series Value. Enter the Task here. You will see a spreadsheet having a little red arrow on the right side of Series values.
Opening the Series Values, you will see a smaller Edit Series window. Click the first date and drag it to the last one. It highlights the tasks to be copied to the Gant Chart. Don’t highlight header or other cells by mistake.
Once you are done with this step, click the small spreadsheet icon again.
Step 4: Add The Task Duration and Repeat the Steps Explained Above
On Select Data Source window, click Add and go to Edit Series window and start adding Task duration by following the third steps.
The duration data will be added to the chart.
- Click an empty space on Edit Series window and click header showing duration.
- In Edit Series window, move the Series value and click on icon having a small red arrow. Once it is done, click the small icon again.
- Click first Duration data and drag to the last Duration data. The entire data will be highlighted
- To exit, click the red arrow icon and then click OK while coming back to the last window. You will reach at the Select Data Source window. Click OK to develop your Gantt Chart.
Gantt Chart weekly based template
Step 5: Formatting the Gantt Chart
Click on the blue area to select the tasks bars. Right-click and choose the Format Data Series and go to Format Data Series window.
Stay close on the Format Data Series window and click Fill & Line icon. Under Fill, select the button of No Fill and No Line. Don’t close Format Data Series because you would need it.
Now you re-order the data (the top and bottom chart) by:
- Clicking on the list of tasks along the vertical axis to select them all.
- For opening the Format Axis, click on the task titles.
- Check all the check boxes located on the Format Axis under the header Axis Options and subheader Axis Positions.
- And it’s done.