Excel – Creating GANTT Chart (Timeline) From Start Time and Duration

chartsmicrosoft-excel-2010

I am attempting to create a daily graphical timeline from start times and duration. I have three columns: Program Name, Start Time and Duration. The data looks something like this…

enter image description here

The desired output would look something like this…

enter image description here

I found some helpful directions (here and here) but they don't seem to be working. I tried creating a stacked bar chart with the Legend Entries being Start Time and Duration and the Axis Labels as the program names, but my chart turns out like this.

enter image description here

It seems that most of these directions are based off of a start date, not a start time, which I'm wondering is the issue. Any help would be greatly appreciated!

Best Answer

I'm not sure what happened on your example, but this is a pretty straightforward Excel charting task. Here's another look at the process:

  1. Enter your data (the format from your sample is fine, it doesn't have to be dates).
  2. Create a new Stacked Bar Chart.
  3. Add Start Time as your first data series (first chart below) and Program Name as your Horizontal X Axis Labels.
  4. Add Duration as your second data series (second chart below).
  5. Reformat your first data series Start Time to No Fill to hide. (third chart below)
  6. Reformat your Horizontal Axis to suit (fourth chart below). I used the following values:
    • Min: 0
    • Max: 1 (1 day or 24 hours)
    • Major: 0.25 (6 hours)
    • Minor: 0.04166 (1 hour)

gantt steps

Related Question