Gantt Chart problem - using time

**jlink3** · 07-04-2012, 02:46 AM

I am creating a gantt chart for making a cup on coffee. Start times from 9.00am and duration is in seconds. Got the chart with bars but they won't overlap but all start on the same time...
Can anyone help. Have hopefully attached file properly. cheers Janene

**DBY** · 07-04-2012, 11:19 AM

Hello Janene
Take a look at the attachment. Sheet2 has my attempt at a Gantt chart. If it's what you're trying to do, it might give you an idea how to proceed.

Just thought I'd add a link to a video that shows how it's done, might be of help.

http://www.youtube.com/watch?v=HQwE0Xv1lAA

Hope this helps.
DBY

**ben_hensel** · 07-04-2012, 11:22 AM

You need to create a dummy series that will be turned invisible (literally; the bar fill color will be set to "no") that the measured times will stack on top of.

The directions.

I've attached a copy of yours, built that way.

(I make Gantt charts pretty often, so I've actually saved my preferred set-up as a custom template).

EDIT:
Aaand I blasted through that pretty quickly and didn't notice you need to differentiate between manual and unattended machine operations... anyway those just go on two different columns, with the helper column adjusted accordingly.