I have some data as shown below:
ID Process Start Process Step one completed All Steps Complete
10 A 6/19/2012 18:32 6/19/2012 21:31 6/20/2012 0:14
10 B 6/20/2012 0:13 6/20/2012 0:24 6/20/2012 1:27
20 A 6/19/2012 18:31 6/19/2012 18:40 6/19/2012 22:22
20 B 6/19/2012 22:22 6/19/2012 22:30 6/19/2012 23:30
30 A 6/19/2012 19:32 6/19/2012 21:21 6/20/2012 1:38
30 B 6/20/2012 1:38 6/20/2012 1:47 6/20/2012 1:54
I need to create a graph with time as x-axis & ID as Y-axis. ID has multiple rows.
For example : For ID 10, Process A starts at 6/19/2012 18:32 , Step one gets completed at 6/19/2012 21:31 and the entire process gets completed at 6/20/2012 0:14. As soon as Process A stops, Process B for the same ID (10) starts: 6/20/2012 0:13 . Step one for process B gets completed at 6/20/2012 0:24 and all the steps gets completed at 6/20/2012 1:27
So for ID 10, I want a stacked bar graph with time as x-axis & time taken by each process stacked one after other.
Attached is a sample excel sheet & the jpg of the expected graph
Any help is greatly appreciated.
Bookmarks