Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I would like to create a chart for my source control depicting the trunk and all the branches, with various details, like creation date, merge date, created revision, merge revision, close revision etc.

I want it to look like this:

enter image description here

I have looked into an appliation called SmartDraw, but unable to the required kind of output from it.

It would be awesome if the data can be generated by reading an Excel file input.

It would be required that the software runs on Windows XP SP3.

share|improve this question
    
what source control do you use? –  Toby Allen Apr 17 '12 at 6:34
    
SVN, with Subclipse plugin in Eclipse, but the structure of my repository is messed up and i cant change that, so i need to create this diagram from the data form an excel, so I cant use the 'Revision Graph' functionality from SVN –  justshams Apr 17 '12 at 6:51

1 Answer 1

up vote 3 down vote accepted

Since your data is already in Excel, I'd just use that to chart your data. You can "fake" a timeline by using an XY chart, with each "branch" sharing the same Y value (so they're all level) and the X values are driven by your date/time fields. Create a single dummy series for your X axis spacing and labels and label your data points based upon your series names, or other values (I use XY Chart Labeler, free add-in from Rob Bovey) you mentioned.

It's not quite as pretty as your example, but it keeps the data in Excel, doesn't require additional software, and by using some dynamic named ranges, your chart can update as your Excel data grows, keeping your chart up-to-date.Excel Timeline

Also, if you add an additional data series formatted as a bar chart, you can use some banding to show general groupings of various "families" of revisions. I added a sample in the second image.enter image description here

share|improve this answer
1  
I am trying to understand how to create this. Could you help me understand a little better, I asked about it here –  maj nem ɪz dæn Mar 7 '13 at 17:29
    
Nice approach. You should consider posting the example document as a reference. –  John Jul 8 '13 at 22:03

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.