Timeline chart in Excel
        Posted  
        
            by Axarydax
        on Super User
        
        See other posts from Super User
        
            or by Axarydax
        
        
        
        Published on 2010-06-07T13:24:23Z
        Indexed on 
            2010/06/07
            13:33 UTC
        
        
        Read the original article
        Hit count: 1058
        
Hi, I'd like to see a timeline of events from a database in a "timeline chart", that should look like this: http://i46.tinypic.com/sw3dj5.png - I've made me a small c# program that paints this onto a Bitmap, but that isn't the way to go.
I have input data that has 3 fields:
StartX  EndX    Y
2596    15008   1
5438    6783    2
5450    5453    4
5456    5459    4
5462    5466    4
5470    5474    4
5477    5657    5
5662    5665    4
5668    5671    4
As the picture shows, for each line I'd like to have a line from StartX to EndX with a Y value of Y. 
Stacked bar chart almost solves my problem, but I don't want to have a new line on the chart for every row, I have thousands of rows and I'd like to have X axis as the time axis, and view which events (Y is the type of the event) happened simultaneously. The image ( http://i46.tinypic.com/sw3dj5.png) I've generated with a simple C# program shows that the event SYSTEM was active all the time, and the events TECH and BREAK were almost exclusive, but had some overlaps. 
I'd like to at least know the correct direction which I should take; I'm lost in the multitude of Excel chart types. Thanks.
© Super User or respective owner