Options for making a Gantt chart Microsoft Excel has a Bar chart feature that can be formatted to make an Excel Gantt chart. If you need to create and update a Gantt chart for recurring communications to clients and executives, it may be simpler and faster to create it in PowerPoint. On this page, you can see both ways. I will give you step-by-step instructions for making a Gantt chart in Excel by starting with a Bar chart. I will also show you how to instantly create an executive Gantt chart in PowerPoint by pasting or importing from Excel. • Break down the entire project into chunks of work, or phases. These will be called, and they form the basis of your Gantt chart. • In Excel 2007, 2010, 2013 or 2016, enter your data by listing the Start Date and Finish Date of each task, as well as its Duration (count of days required to complete that task). Also include a brief description of the task. As a significant point or event in your project, all project milestones should be listed and tracked. Download our Free Milestone List Template. Make sure to sort these tasks in order, by placing the earliest start date first and the latest start date last. • In this tutorial, I will convert the following table into an Excel and a PowerPoint Gantt chart. • Right-click the white chart space and click Select Data to bring up Excel's Select Data Source window. • On the left side of Excel's Data Source window, you will see a table named Legend Entries (Series). Click on the Add button to bring up Excel's Edit Series window, and here you will begin adding Task data to your. • Now we're going to add your task data. First we need to name the data (Series) we will be entering. Click and place your cursor in the empty field under the title Series name, and then click on the column header that reads Start Date in your table. Staying in the Edit Series window, move down to Series value. This is where you will enter your Task start dates. It is easy to do. To the right of the Series values field, you will see an icon which looks like a spreadsheet with a red arrow on it. Click on it (the one by Series values), and Excel will open a smaller Edit Series window. Now simply click the first start date in your task table and drag your mouse down to the last start date. This highlights all of the start dates for your tasks and inputs them into your Gantt chart. Make sure you have not mistakenly highlighted the header or any extra cells. When finished, click on the small spreadsheet icon again (the one with the red arrow), which will return you to the previous window, called Edit Series. Your Gantt should now look like this. • Staying in the Select Data Source window, click on the Add button again to bring up Excel's Edit Series window. • Here we will add the duration data to your Gantt chart. In the Edit Series window, click in the empty field under the title Series Name, and then click in your Task table again, on the column header that reads Duration. Staying in the Edit Series window, move down to Series value and click on the spreadsheet icon with a red arrow on it again.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
April 2018
Categories |