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. Download your free gantt chart excel template! It's easy to use & integrates seamlessly with Excel to tailor to your project's schedule and tasks. Download a Free Gantt Chart Template for Microsoft Excel. Easily create a gantt chart for your project, with no learning curve. 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. 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. Select your Duration data by clicking on the first Duration in your project table and drag your mouse down to the last duration so that all durations are now highlighted. To exit, once again click on the small spreadsheet icon with the red arrow, which will return you to the previous window. Select OK, and you should now be back at the Select Data Source window. Click OK again to build your Gantt chart, which should now look something like this. • Right-click on one of the blue bars in the Gantt chart, and then click on Select Data again to bring up the Select Data Source window. • On the right side of Excel's Data Source window you will see a table named Horizontal (Category) Axis Labels. Select the Edit button to bring up a smaller Axis Label windows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
April 2018
Categories |