agenda-style graph

**Maistro_44** · 12-13-2012, 03:50 AM

Hi, I'm trying to make a graph as in the example. The example is made by calculating the duration of each step and using a stacked bar. This is a lot of work and I'd rather plot it directly based on start time and finish time. Any body a clue into which direction to search?

Start Finish
07:44:19 07:55:46 Order 1
07:57:37 08:51:14 Order 2
09:10:42 09:12:06 Order 3
09:13:27 10:28:19 Order 4
11:12:52 11:49:15 Order 5
11:52:36 11:56:02 Order 6
12:03:23 12:44:27 Order 7
13:00:54 13:02:26 Order 8
13:23:24 14:30:56 Order 9
14:39:04 15:08:56 Order 10

example.png

**Maistro_44** · 12-24-2012, 05:37 AM

This is a bump

**RHCPgergo** · 12-27-2012, 08:49 AM

Can you psot a workbook with your stacked bar example?

**Maistro_44** · 01-02-2013, 10:29 AM

example.xlsx

Here's an example.

**RHCPgergo** · 01-02-2013, 12:05 PM

I looked into it and although I know of no better way to display it easier or faster, I will try to come up with a macro solution to speed up the process.

edit: tomorrow, cause I'm off now.

**RHCPgergo** · 01-03-2013, 06:14 AM

This is what I came up with. You just run the macro and the chart is drawn. I've tried to match the formatting to your example. Also, orders have correct names now.