How To Use Excel Gantt Chart

Enter the project name worksheet name project lead and the estimated baseline budget for the project.

How to use excel gantt chart. Now click on the inserttab click on the bar chart icon 2 in charts section and select stacked bar 3 option in the drop down menu. Next click on the insert tab bar chart stacked bar chart. Click on the add new gantt chart button to bring up the project details window. Be sure to select only the cells with data and not the entire column. To do that select your task information.

This will insert a blank stacked bar chart in your worksheet. A gantt chart in excel. To print a particular part of it you have to select the area to print by clicking at a starting point then drag out your selection to cover the target area. The gantt menu tab in the excel ribbon will instantly load see image below. Select a range of your start dates with the column header it s b1 b11 in our case.

In the top toolbar select chart design add chart element chart title and select above chart. Then go to file print area set print area. You begin making your gantt chart in excel by setting up a usual stacked bar chart. You can use microsoft excel to make gantt charts but using a dedicated program is usually a lot easier. Instead we ll improvise and create one using a stacked bar chart.

Click kutools charts point in time gantt chart. If you want to edit the bar color used in the gantt chart you will need to edit the conditional formatting rules. If you like hard copies of charts that you can easily stick to the wall you can print the whole gantt chart or just part of it. Click once on the chart. Go to home conditional formatting manage rules and select this worksheet to see and edit all the rules.

So your first step should be to name both the project workbook and the chart itself. Excel does not come with an inbuilt gantt chart. Switch to the insert tab charts group and click bar. Some tools have a button that lets you create dependencies by filling out the details in a. Next click on chart designtab and click on select dataoption located in the data section.