Computer Science homework help

In 1920, Henry Gantt, a U.S. engineer, developed the scheduling and monitoring diagram that bears his name. At the time it was an innovation. Today, the Gantt chart is a standard management tool used by project managers around the world to chart the progress of their projects. Project managers likely use specialized software such as Microsoft Project to create Gantt charts. Another option is to use Excel. You can create a Gantt chart with Excel by customizing a stacked bar chart. So let’s do it by following the steps below.

1. Enter the data from the table in Figure 12-23 on page 382 of the textbook into Excel.
2. Select the headers and data for Tasks, Start Date, and Duration (Days) and create a Stacked Bar Chart.
3. Right-click on the chart and click Select Data.
4. In Legend Entries (Series), remove all three series: Start Date,  Duration and End Date.
5. Click on Add to add a new series with Series Name “Start Date” and Series range (depending on how you setup your workbook — B2:B9.
6. Click on Add again to add another new series, with Series Name “Duration (Days)” and Series range C2:C9.
7. Click on the y-axis, select Format Axis, and check the box “Categories in reverse order” to put the rows in order.
8. Right-click on the first part of the first stacked bar and choose Format Data Series.
9. Choose Fill, then click No Fill to make those parts of the stacked bar invisible.
10. To start the chart at the project’s start date, you need to correct that axis. Excel converts June 1, 2013, to 41426, which you can see for yourself if you change the format of the cell to numeric rather than date.
11. Now click on the x-axis at the top of the chart, and select Format Axis.
12. Change the Minimum to Fixed, and then enter 41426.
13. Finally, delete the legend at the right or bottom of the chart.
14. Your Gantt chart should look similar to the one shown below in Figure 12-24 on page 383 of the textbook. If you need more help, you can find videos that walk you through the process on YouTube by using the search terms “Excel Gantt Chart.”