Visualize overlapped data

[dreamcatcher]

Hi All,


I have a process with many sub-processes. Subprocesses (SB) measured in [minutes:second] format.

I’d like to visualize the data, but there are some parallel or overlapped subprocesses.

As you can see in the linked picture, my problem is that the SB5 is starting earlier than the SB4 is finishing.

Is there any good way to visualize this?


http://tinypic.com/r/15ygs3t/7

 

[Luke M]

How about using a Gantt chart (bars which move left and right to show start/end, length corresponds to duration.


Here's an example of a simple approach:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343

 

[dreamcatcher]

Thanks for you reply. I tried it out, but almost all of the bars are overlapped. :/


http://i55.tinypic.com/2582sci.jpg


The other thing is the scale: SB8 lasts 41:16, but in the chart lasts longer. (and I'm wondering what is 12:00 at the end of the scale...?)

 

[Luke M]

Looks like you have your chart using the End Time as the duration. You need to change that. This is causing the bars to be too long and they overlap.


I'd also recommend manually setting the scaling of the x-axis to something that makes sense, maybe every 2 hrs?


No idea what the 12:00 at the end is for...

 

[dreamcatcher]

Thanks, it's working! As I set the sources of the chart properly everything became fine. And the 12:00 also disappeared. Thank you again!

 

[Luke M]

Glad it's working, and you're very welcome. =)