Your On-line Resource for Gantt Chart Templates
Excel 2010 Gantt Chart Template
If you don’t own dedicated Gantt chart software you can create simple Gantt charts in Excel by creating a customised stacked bar chart. You can then save the Gantt chart as a template.
This tutorial applies to Excel 2010, but the same thing can be achieved in other versions of Excel.
Start off by creating a table of tasks as shown opposite
Click anywhere in the data and press the F11 key on your keyboard to create a chart
on a separate sheet. -
Click on Change Chart Type button on the Ribbon and select the stacked bar chart as your chart type and click OK to confirm.
Select the stacked bar chart as your chart type and click OK to confirm.
