Create a Gantt Chart Using the Gantt Excel Tool

A quick tutorial to show you how to create a Gantt chart in Excel using the Gantt Excel Template.

Steps

  1. Click on the Add Gantt chart button, enter project details and click the Ok button.
  2. Instantly, you will have a Gantt chart slide with a timeline. A new section and task is created for you by default so that it is easy for you to get started.
  3. Double click Section 1 or select Section 1 and click the edit button
  4. Double click Task 1 or select Task 1 and click the edit button
  5. Add a new section or task by clicking the Add buttonFrom here you can easily customize the Gantt chart, adding milestones, formatting fonts and colors, and adding various details like percent complete etc…
  6. In my example below, I added milestones, changed colors for the timeband and changed the image from a flat look to a Gel look. For example, with some tweaks, you can create a timeline that’s sure to impress:And that’s how easy it is to create Gantt charts in Excel.

Tips

  • You can also use shortcuts.ALT GC = Add Gantt ChartALT GM = Set MilestonesALT GA = Add Section/ Task