Creating a Gantt Chart in Excel

Summary

Describes how to add a bar chart in excel. This can be used to show the duration of items.

Body

Issue/Question

How do I create a Gantt chart/bar chart in excel

Environment

  • Excel 2016

Cause

I want to show a time line for items 

Resolution

  1. Add columns for the following:
    1. Names you want shown in the axis of the chart
    2. Start date
    3. End date
    4. Duration
  2. Follow these instructions:
     
  3. Free official templates can be downloaded directly from Microsoft

Details

Details

Article ID: 2199
Created
Wed 2/6/19 11:59 AM
Modified
Fri 4/8/22 11:38 AM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated