How To Draw Gantt Chart In Excel

Present your data in a Gantt chart in Excel

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2022 Excel 2022 for Mac Excel 2022 Excel 2022 for Mac Excel 2022 Excel 2022 for Mac Excel 2022 Excel 2022 Excel 2007 More...Less

A Gantt chart helps you schedule your project tasks and and so helps y'all track your progress.

Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn't take a predefined Gantt nautical chart type, you tin can create one using this free template: Gantt project planner template for Excel

Need to show status for a unproblematic project schedule with a Gantt chart? Though Excel doesn't have a predefined Gantt chart blazon, you can simulate one by customizing a stacked bar chart to testify the start and finish dates of tasks, like this:

Sample simulated Gantt chart

To create a Gantt chart like the 1 in our example that shows task progress in days:

Select the data you desire to nautical chart. In our instance, that'due south A1:C6

If your data's in a continuous range of cells, select any cell in that range to include all the data in that range.

If your data isn't in a continuous range, select the cells while belongings downward the Command cardinal.

Tip:If you lot don't want to include specific rows or columns of information you lot can hide them on the worksheet. Find out more about selecting data for your chart.
Click Insert > Insert Bar Nautical chart > Stacked Bar chart.
Next, we'll format the stacked bar chart to appear like a Gantt chart. 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.
If you don't demand the fable or nautical chart championship, click information technology and press DELETE.
Allow's also reverse the task order so that it starts with Task1. Concord the Control key, and select the vertical axis (Tasks). Select Format Axis, and under Axis Position, choose Categories in reverse order.

Customize your nautical chart

You lot tin customize the Gantt type chart we created by adding gridlines, labels, changing the bar colour, and more than.

To add elements to the chart, click the chart area, and on the Nautical chart Design tab, select Add Chart Element.
To select a layout, click Quick Layout.
To fine-tune the pattern, tab through the design options and select 1.
To change the colors for the chart, click Change Colors.
To reuse your customized Gantt chart, salve it as a template. Hold Control and click in the nautical chart, and so select Salve as Template.

Did you know?

Microsoft 365 subscription offers premium Gantt chart templates designed to help you rail project tasks with visual reminders and color-coded categories. If y'all don't have a Microsoft 365 subscription or the latest Office version, you tin can try it now: