GANTT CHART EXCEL HOW TO
GANTT CHART EXCEL SERIES

GANTT CHART EXCEL SERIES

In the Format Data Series task pane, click on the Fill & Line icon (it looks like a paint can) to get the Fill & Line options. To select all of the tasks bars at once, click on the blue part of any bar in your Gantt chart, then right-click and select Format Data Series, which will bring up the Format Data Series window in Excel. These will become the tasks of your Gantt chart. To do that, we must make the blue parts of each task bar transparent so only the orange parts will be visible. Now we need to format it so it looks like a Gantt chart. You have really built a Stacked bar chart. Your chart should now look something like this:Д¦.В Format your chart so it looks like a Gantt chart When you are done, exit this window by clicking on the small spreadsheet icon again.Д¬lick on OK and then OK again to exit the Select Data Source window, and now your Gantt chart should have the correct Task descriptions next to their respective bars. Be careful not to include the name of the column itself. Click on the first name of your tasks (my first Task description is 'Preparatory Phase'Вќ) and select them all.

Select the Edit button to bring up a smaller Axis Label windows.ДЄgain, click on the small spreadsheet icon. On the right side of Excel's Data Source window you will see a table named Horizontal (Category) Axis Labels. Right-click on one of the blue bars in the Gantt chart, then click on Select Data again to bring up the Select Data Source window. Click OK again to build your Gantt chart which should now look something like this:ДҐ.В Add the descriptions of your Tasks to the Gantt chart Select OK and you should now be back at the Select Data Source window. To exit, once again click on the small spreadsheet icon with the red arrow to which will return you to the previous window. Select your Duration data by clicking on the first Duration in your project table and drag your mouse down to the last duration so all durations are now highlighted. Staying in the Edit Series window move down to Series value and click on spreadsheet icon with a red arrow on it In the Edit Series window, click in the empty field under the title Series Name, then click in your Task table again, on the column header that reads Duration. Here we will add the duration data to your Gantt chart. Staying in the Select Data Source window, click on the Add button again to bring up Excel's Edit Series window. Your Gantt should now look like this:Д¤.В Add the durations of your Tasks to the Gantt chart (the one with the red arrow) which will return you to the previous window called Edit Series. When finished, click on the small spreadsheet icon again Make sure you have not mistakenly highlighted the header or any extra cells. This highlights all of the start dates for your tasks and inputs them into your Gantt chart. Now simply click the first start date in your task table and drag your mouse down to the last start date. To the right of the Series values field you will see an icon which looks like a spreadsheet with a red arrow on it.Д¬lick on it (the one by Series values) and Excel will open a smaller Edit Series window. This is where you will enter your Task start dates. Staying in the Edit Series window move down to Series value. Click and place your cursor in the empty field under the title Series name, then click on the column header that reads Start Date in your table. First we need to name the data (Series) we will be entering. Click on the Add button to bring up Excel's Edit Series window and here you will begin adding Task data to your On the left side of Excel's Data Source window you will see a table named Legend Entries (Series). Right-click the white chart space and click Select Data to bring up Excel's Select Data Source window. Select Stacked Bar which will insert a large blank white chart space onto your Excel worksheet (do not select 100% Stacked Bar).ДЈ.В Add the start dates of your Tasks to the Gantt chart In the Charts section of the ribbon, drop down the Bar Chart selection menu. Then from the Excel ribbon, select the INSERT tab. In this tutorial, I will convert the following table into an Excel Gantt chart and a PowerPoint Gantt chart:Дў.В Begin making your Excel Gantt by setting it up as a Stacked Bar chartДЇrom the same worksheet that your Excel table is on, click in any blank cell. Make sure to sort these tasks in order, by placing the earliest start date first and the latest start date last. Also include a brief description of the task. In Excel 2007, 2010, 2013 or 2016, enter your data by listing the Start Date and Finish Date of each task, and also it's Duration (count of days required to complete that task). These will be called project tasks and they form the basis of your Gantt chart.

GANTT CHART EXCEL HOW TO

Download Excel Gantt chart template How to make a Gantt chart in Excel 1.В List your project schedule in an Excel tableД«reak down the entire project into chunks of work, or phases.

Gantt chart excel