Repeat this process to add a second entry called “Duration,” making sure to select the data in the Duration column for the Y values. Name it "Start Date." Then click on the Y values field, and select the data in the Start Date column. Right-click the chart, and choose Select Data.Ĭlick the plus sign (+) under the Legend entries section to add the first data set. You should see a blank chart in your Excel worksheet now. This chart type most closely resembles a gantt chart. Choose Stacked Bar from the 2-D Bar section to add a chart to your Excel worksheet. Insert a Stacked Bar Chart from the Insert menuĬlick the Insert tab, and select the bar chart icon. Place your mouse on the right corner of D2 until you see a black + sign and double-click or drag your mouse down to paste the formula in the remaining cells in column D. Tip: If you started in different cells in your worksheet, be sure to adjust this formula accordingly. For example, we entered =C2-B2 into the Duration field for our first task. That way your Excel worksheet will automatically calculate the length of each task in your gantt chart. Use a simple formula to subtract the start date from the end date. Apply an automatic formula to calculate task duration
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |