Now your chart would look something as shown below.In the Axis Labels dialogue box, select the range that has all the activities names.In the Select Data Source dialogue box, in the right half of the pane titled Horizontal (Category) Axis Labels, click on Edit.Again click on Add in Select Data Source dialogue box and use the following data:.In the Edit Series dialogue box, enter the following data: In Select Data Source dialogue box, click on Add.In the Design Tab, Go to Data Group and click on Select Data. Select the Chart and go to Design tab.This will insert a blank chart in the worksheet.

Go to Insert –> Charts –> Bar Chart –> Stacked Bar.

Number of Days it takes to complete the activity.

Here are the steps to quickly create this Gantt Chart in Excel: Download the Example File Creating a Gantt Chart in Excel Wayne when asked for a status report:įollow Along. Alfred, who is an avid project management student, comes up with a simple Gantt Chart in Excel to get the plan ready. Let’s say Bruce Wayne ( Batman) wants a new Batsuit and instructs Alfred (the butler and his confidante) to get it made. Gantt Chart is a simple yet powerful project management tool that can be used for creating a schedule or tracking the progress. With the charting fever still riding high, today I will show you how to create a Gantt Chart in Excel. Microsoft 365 subscription offers premium Gantt chart templates designed to help you track project tasks with visual reminders and color-coded categories.Last week I wrote an article on how to create a Dynamic Pareto Chart in Excel. Hold CONTROL and click in the chart, and then select Save as Template.

To reuse your customized Gantt chart, save it as a template. To change the colors for the chart, click Change Colors. To fine-tune the design, tab through the design options and select one. To add elements to the chart, click the chart area, and on the Chart Design tab, select Add Chart Element.

You can customize the Gantt type chart we created by adding gridlines, labels, changing the bar color, and more. Select Format Axis, and under Axis Position, choose Categories in reverse order. Hold the CONTROL key, and select the vertical axis (Tasks). Let’s also reverse the task order so that it starts with Task1. If you don’t need the legend or chart title, click it and press DELETE. In the chart, click the first data series (the Start part of the bar in blue) and then on the Format tab, select Shape Fill > No Fill. Next, we’ll format the stacked bar chart to appear like a Gantt chart. Find out more about selecting data for your chart.Ĭlick Insert > Insert Bar Chart > Stacked Bar chart. Tip: If you don't want to include specific rows or columns of data you can hide them on the worksheet.

Project gantt chart excel template free