Help to make a stacked bar chart to ilustrate a process

[Sebastian K.]

Hi

I'm trying to make stacked bar chart, more or less like a gantchart, to ilustrate a production.

I've got 2 identical productions running which are offset so that one crew can maintain both productions. Each production consist of a number of steps, 1 to 11.

What I want is to create a stacked bar chart with a stack for each production, ilustrating the when the different processes in each production occures with the time line on the x-axis.

At the moment I've got the data presented like this but I can't get the bares to stack correctly.

Any body got any suggestions?

Best regards
Sebastian

 

[Steve=True]

Hi,

Not sure what you want the graph to look like.

Here is my version of what you described.

http://www.4shared.com/document/gXE6SsuG/Process_Time_Graph.html

Let me know what you think.

Steve=True
www.exceldashboardtemplates.com

 

[Jon Peltier]

Are the times in your table the start times? You need to plot durations. The first step starts later than zero? You need a duration for step zero, and you can make ths bar transparent if you want (no fill, no border).

Set up your data like this:

               Step 0  Step 1  Step 2  Step 3  Step 4  Step 5  etc.
Production 1    1:00    1:00    1:00    1:00    4:00    1:00   etc.
Production 2    1:00    2:30    1:00    0:50    1:00    1:00   etc.

Make a stacked chart, with series in columns.