Excel Gantt Chart Template

Gantt charts pictorially show the status of project plan tasks and phases.

A gantt chart uses bars to show the start and end date of each task and each task in relation to the others.

Gantt Chart in Excel created using the QI Macros SPC Software

gantt-chart-template

To create a Gantt Chart using the QI Macros Excel Template

  1. Identify major project milestones or phases.
  2. Identify the tasks under each milestone.
  3. Determine the number of hours required to complete each task and the task start and end dates.
  4. Input the information into the Gantt chart template.
    • Input data into the yellow shaded areas.
    • Copy and paste rows to add project phases and tasks.
  5. Update the formulas in the rows representing project phases to match the tasks for that phase.

The QI Macros for Excel also includes a Gantt Bar Chart

gantt-complete-chart

To Edit the Horizontal Axis of the Gantt Bar Chart

  1. Click the horizontal axis, so there is a box around it:
  2. Gantt Bar Chart Horizontal Axis

  3. Double-click the highlighted area, so that the Format Axis opens, and select Axis Options. Switch Axis Options Minimum to “Fixed” and change the value to the date you wish:
  4. Gantt Bar Chart Axis Options

  5. Select "Close." It will then format the "Minimum" to a value representative of the date:
  6. Gantt Bar Chart Axis Options 2

To Change the Color of the Bars on the Gantt Chart

  1. Select "Manage Rules" under "Conditional Formatting," which is found under the "Home" tab in Excel:
  2. gantt-chart-conditional-formatting.

  3. Next, open the "Edit Formatting Rule" window and select "Format" and "Fill." Select your color, press "OK," then "Apply."
  4. gantt-chart-format

    gantt-chart-format-fill

  5. Repeat this for all (3) rules found in the template.

To Change the Color on Specific Parts of the Bar, on Gantt Chart

  1. Select the cells you wish to change the color of. Then, select "New Rule" under "Conditional Formatting," which is found under the "Home" tab in Excel.
  2. gantt-chart-conditional-formatting

  3. Next, open the "Edit Formatting Rule" window and select "Format only cells that contain." Then, select the cells you wish to change the color of, in "Format only cells with Cell Value between _ and _."
  4. gantt-chart-format-cell-value

  5. Lastly, select your color through the "Format" button, press "OK," then "Apply.
  6. gantt-chart-format-color

Learn More...

Purchase QI Macros SPC Software for Excel or a QI Macros Upgrade through our secure shopping cart or try a free, 30-day trial!

To create a Gantt Chart using QI Macros...
Try It Now!