tailieunhanh - Lecture Business driven technology (Technology plug-in): Chapter 12 - Paige Baltzan, Amy Phillips

Chapter 12 - Creating Gantt charts with excel and microsoft project. Explain what a Gantt chart is, describe the main steps involved in creating a Gantt chart using excel, describe the main steps involved in creating a Gantt chart using microsoft project. | TECHNOLOGY PLUG-IN T12 Creating Gantt Charts With Excel And Microsoft Project LEARNING OUTCOMES Explain what a Gantt Chart is Describe the main steps involved in creating a Gantt Chart using Excel Describe the main steps involved in creating a Gantt Chart using Microsoft Project INTRODUCTION Henry Gantt developed the famous Gantt Chart as a tool for scheduling work in factories A Gantt Chart is a standard format for displaying project schedule information by listing project activities and their corresponding start and finish dates in a calendar format INTRODUCTION Gantt Chart in Excel INTRODUCTION Gantt Chart In Microsoft Project CREATING GANTT CHARTS WITH EXCEL Excel does not offer Gantt as a chart type, but it is fairly easy to create such a chart by using a stacked bar chart To do so, follow these steps: Start with a new workbook and enter the task data (see the next slide for our example) Column A contains the task descriptions Column B contains start date for each task Column C | TECHNOLOGY PLUG-IN T12 Creating Gantt Charts With Excel And Microsoft Project LEARNING OUTCOMES Explain what a Gantt Chart is Describe the main steps involved in creating a Gantt Chart using Excel Describe the main steps involved in creating a Gantt Chart using Microsoft Project INTRODUCTION Henry Gantt developed the famous Gantt Chart as a tool for scheduling work in factories A Gantt Chart is a standard format for displaying project schedule information by listing project activities and their corresponding start and finish dates in a calendar format INTRODUCTION Gantt Chart in Excel INTRODUCTION Gantt Chart In Microsoft Project CREATING GANTT CHARTS WITH EXCEL Excel does not offer Gantt as a chart type, but it is fairly easy to create such a chart by using a stacked bar chart To do so, follow these steps: Start with a new workbook and enter the task data (see the next slide for our example) Column A contains the task descriptions Column B contains start date for each task Column C contains the number of days to complete the task Column D contains formulas that determine the end date for each task The formula used in our example in cell D4 is =B4+C4 CREATING GANTT CHARTS WITH EXCEL CREATING GANTT CHARTS WITH EXCEL Create a stacked horizontal bar chart by selecting the Insert tab, then choose the Bar button in the Charts ribbon, and then the 2-D Stacked Bar Chart option A blank chart appears in your spreadsheet To select the data, right mouse click anywhere inside the blank chart, then choose Select Data CREATING GANTT CHARTS WITH EXCEL CREATING GANTT CHARTS WITH EXCEL Under the Legend Entries (Series) section, click on the Add button The first series to add will be the label containing the start date Under the Series Name, select cell B3 Under the Series Values, select cells B4:B13, the range of cells containing the various start dates Click OK Another series is needed, therefore click on the Add button This series will be the duration When the Edit Series dialog