When the Edit Series window opens, you have to type in “Length” or any other name of your choosing in the Name field of the Series. In case you want to add more data to the chart, you can click the Add button to select the required data. Once the Select Data Source window opens, you will see that you need to enter the Start Date. To do this, right-click anywhere within the chart and then select Select Data from the following menu box. Once you have the stacked bar on your sheet, you can proceed to add data of one or more series in the chart. Click Stacked Bar under the 2-D Bar section. Turn to Insert tab and select Group charts and click Bar. Make sure that you only select those cells which have data and not the whole column. To do this, from the column header, you need to choose a range of your start dates. You start creating your Gantt chart in Excel by creating a regular Stacked Bar chart. Chart each task in a separate row and frame your project plan by inserting the start date, end date and duration (the total number of days required to complete the tasks). You begin by entering the data in an Excel spreadsheet for your project. Download Steps on How to Make a Gantt Chart in MS Excel Step 1: Make a Project Table
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |