We need to remove the blue bars so that only the parts representing the project tasks will be visible.Ĭlick a blue bar > Right Click > Format Data Series You can hold shift and click on the first cell and the last cell – this will highlight all of the cells in between as well.Īs seen above, you now have a cool looking stacked bar graph, but it's not a Gantt chart yet. Select the cells containing all of your tasks. Then the mini edit series will open again. Right-Click anywhere in the chart area > Select Data > Edit: Once all the Edit Series screens have been okayed, the resulting graph should appear as seen below:įrom here, you need to edit the information even further using the edit series menu from before. To finalize this step, click to minimize the screen > Ok > Ok Select your project Duration data by clicking on the first Duration cell all the way to the last Duration – in our example, we're using D2 to D6.ĭ1 and D7 aren't included because they are a header/empty, respectively. Then click the arrow next to the series values: This will open up the edit series menu which allows you to type the duration into the series name which will effectively add it to the series. As you can see, the Date is already added under Legend Entries (Series) but now you need to add Duration as well. You should Right Click > Select Data:įrom here you’ll open a menu that lets you choose an additional data source. Right click anywhere in the area of the chart and access the menu. Once added, we're going to begin formatting and manipulating the bar chart to make it look like a Gantt chart.įirst, you need to add an additional series to your graph. Insert > Charts > Bar > 2-D Bar > Stacked Bar: In order to create the Bar graph, highlight the starting date data and click: To calculate duration, use the formula as shown in the screenshot below:įrom here, you need to create a stacked bar chart from the starting date data. You can add as many dates and tasks as you want. This is where you add in your specific projects with their corresponding dates and duration. To begin, create a project table, a list of the projects with start dates, end dates and the duration of the project. Making a Gantt Chart in Excelīy utilizing the bar graph offered in Excel, you can format it to function as a Gantt chart. In this tutorial, you're going to learn how to make a Gantt chart in Excel, step by step. Unfortunately, it is a bit harder to make a Gantt chart in Excel than with a dedicated Gantt chart tool, but not impossible. There is a way to display the information from your Excel document in Gantt chart format in the same spreadsheet. Excel doesn't have a Gantt chart template to insert built-in, but that doesn't mean we can't make one.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |