gantt chart excel template free download

For this reason, we created Gantt Excel, an automated excel template that allows you to create awesome Gantt Charts within Excel. There’s just one thing that Excel is not good at and that is creating Gantt charts. Modern Gantt charts also show the dependency relationships between activities and current schedule status.Įveryone uses Microsoft Excel almost every day for almost everything – from a simple calculator to tracking massive projects. Microsoft Excel is instantly familiar, so everyone on your team “gets it” and hits the ground running.Ī Gantt chart is a type of bar chart that illustrates a project schedule, named after its inventor, Henry Gantt, who designed such a chart around the years 1910–1915. If you use Microsoft Excel, you can create a Gantt Chart with almost no learning curve by downloading Gantt Excel. Gantt Excel is completely automated and is super easy to use. Microsoft 365 subscription offers premium Gantt chart templates designed to help you track project tasks with visual reminders and color-coded categories.Download Free Gantt Chart Excel Template and Create Professional-looking Gantt Charts 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.

Gantt chart excel template free download