Gantt Chart In Excel 2010 is being widely use in project management for scheduling project activities. It is created in MS Excel. Most of the Excel formats do not have in-built Gantt chart options, therefore the project managers are required to create the Gantt by themselves in the Microsoft Excel spreadsheet. In this regard, the MS Excel versions of 2007, 2010, and 2013 are suitable for creating this chart.
This Chart is a graphical illustration of project activities, therefore, you have to insert data in the Excel sheet for creating the Chart in it. It would not take more than 2 minutes to create the Chart once you have entered all the data in the MS Excel spreadsheet. Below is a tutorial for creating the Gantt Chart In Excel. You can follow the same procedure for creating the Chart in MS Excel 2013.
Steps for Making Gantt Chart In Excel 2010
First of all you need to create a project table. This implies that you enter the data in the columns and the title of each data in the description column which represents the tasks or phases of a project. Mention the starting date and date of completion in separate columns and also mention the duration took by each task for completion. If you are creating this table or Gantt Chart during the project and some tasks of the project have not completed yet, then you can make a separate column in which you will mention the expected date of completion of incomplete tasks. List all the tasks of the project and their respective duration’s.
Create a standard Excel chart by using the data you inserted in the project table. You can select the ‘Stacked Chart Bar’ option for creating your chart. Choose the range for your start dates, and then task completion dates. Do not select the entire column. Go to the ‘Insert’ tab and then go to the ‘Charts’ and select a bar chart. Select the Stacked Bar Chart. It will show a Stacked bar in your Excel sheet.
Insert the duration data in the chart you created in step 2. For selecting the data, make a right click in the area of the char and the option of ‘Select data’ will appear; click it and select the data from the table once the Select Data window appears in the sheet. You can add more data by clicking on the button ‘Add’ in the Select Data window. Once you clicked on the ‘Add’ button, the edit series list will appear. You can edit the range of data in this list. To exit from this series, click on the Range Selection option in this dialog box window and click ‘Ok’ once you have edited and finalized the range. Now your bar chart is ready and it will display in the Gantt Chart In Excel 2010 as follows:
Transform this chart into the Gantt Chart by hiding the blue bars. You just need to do a right click on the blue bar and have to make it transparent by selecting a suitable color for it. It will let the orange bars to appear only. Now your Gantt Chart In Excel 2010 has been created. You can make additions in it as per your preferences.