Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Present your data in a Gantt chart in Excel

A Gantt chart helps you schedule your project tasks and then helps you track your progress.

Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can create one using these free Gantt chart templates.

Sample simulated Gantt chart Example of a Gantt chart in Excel

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

Sample simulated Gantt chart

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

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

    sample table data for the Gantt chart

    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 holding down the COMMAND key.

    Tip: If you don't want to include specific rows or columns of data you can hide them on the worksheet. Find out more about selecting data for your chart.

  2. Click Insert > Insert Bar Chart > Stacked Bar chart.

    On the Insert tab, select Bar Chart, and then select Stacked Bar Chart

  3. 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.

    On the Format tab, select Fill, and then click No Fill

  4. If you don’t need the legend or chart title, click it and press DELETE.

  5. Let’s also reverse the task order so that it starts with Task1. Hold the CONTROL key, and select the vertical axis (Tasks). Select Format Axis, and under Axis Position, choose Categories in reverse order.

Customize your chart

You can customize the Gantt type chart we created by adding gridlines, labels, changing the bar color, and more.

  • To add elements to the chart, click the chart area, and on the Chart Design tab, select Add Chart Element.

    On the Chart Design tab, select Add Chart Element

  • To select a layout, click Quick Layout.

    On the Chart Design tab, select Quick Layout

  • To fine-tune the design, tab through the design options and select one.

    On the Chart Design tab, select a chart format

  • To change the colors for the chart, click Change Colors.

    On the Chart Design tab, select Change Colors

  • To reuse your customized Gantt chart, save it as a template. Hold CONTROL and click in the chart, and then select Save as Template.

    Hold COMMAND and click the chart, and then select Save As Template

Did you know?

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

See Also

Create a chart from start to finish

Save a chart as a template

Powerpoint presentation templates

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×