How To Make A Gantt Chart Excel

Present your data in a Gantt nautical chart in Excel

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 More than...Less

A Gantt chart helps you schedule your projection tasks and so helps you rails your progress.

Need to show status for a simple projection schedule with a Gantt chart? Though Excel doesn't have a predefined Gantt chart type, yous can create one using this gratis template: Gantt projection planner template for Excel

Need to prove status for a simple project schedule with a Gantt nautical chart? Though Excel doesn't have a predefined Gantt nautical chart type, you tin simulate 1 by customizing a stacked bar chart to evidence the start and finish dates of tasks, similar this:

Sample simulated Gantt chart

To create a Gantt chart similar the ane in our example that shows chore progress in days:

Select the data you want to chart. In our example, that's A1:C6

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

If your information isn't in a continuous range, select the cells while property down the COMMAND key.

Tip:If you don't desire to include specific rows or columns of data you lot tin can hibernate them on the worksheet. Find out more than almost selecting information for your nautical chart.
Click Insert > Insert Bar Chart > Stacked Bar nautical chart.
Adjacent, nosotros'll format the stacked bar nautical chart to appear like a Gantt chart. In the chart, click the kickoff data series (the Start part of the bar in blue) and so on the Format tab, select Shape Fill > No Make full.
If y'all don't need the legend or chart title, click it and press DELETE.
Let's as well opposite the task club so that it starts with Task1. Hold the Command central, and select the vertical centrality (Tasks). Select Format Axis, and nether Axis Position, choose Categories in reverse order.

Customize your nautical chart

You tin can customize the Gantt type chart we created past calculation gridlines, labels, changing the bar colour, and more.

To add elements to the chart, click the chart surface area, and on the Chart Design tab, select Add Chart Element.
To select a layout, click Quick Layout.
To fine-tune the design, tab through the design options and select one.
To change the colors for the chart, click Change Colors.
To reuse your customized Gantt chart, save it as a template. Agree Control and click in the chart, and and so select Save every bit Template.

Did you know?

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