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 have two columns of data:

Time Taken: 00:00:42.1093750, 00:00:09.5468750, 00:00:47.2656250, 00:01:27.6718750
Start Time: 21:02:27, 21:33:16, 22:03:27, 22:34:19

I want to make a cluster graph from the two columns so that the "Start Time" will be on the x-axis and the "Time Taken" will be on the y-axis. I've tried to do so myself but the graph came out blank or not even close to what I wanted. Best case I got an backwards graph where the axes were reversed, but replacing the columns didn't work. Can someone please try to make this graph on their computer and tell me how to do so?

share|improve this question

migrated from stackoverflow.com Sep 8 '10 at 12:14

This question came from our site for professional and enthusiast programmers.

    
You're probably going to have to convert all those numbers into decimals instead of times. –  digitxp Sep 8 '10 at 13:21
add comment

1 Answer

up vote 0 down vote accepted

I took a quick shot at this. Is this close to what you are trying to do? I converted your 'Time taken' column to duration in seconds and used an XY graph.

alt text

Hope this is heading in the right direction for you.

share|improve this answer
    
thanks, sorry for the late response. i just found out that my question is here and not in stackoverflow, anyway this is what i did too, thanks for the answer again! –  yishai Sep 27 '10 at 15:51
    
BTW, what is the difference between superuser.com and stackoverflow.com? –  yishai Sep 27 '10 at 15:53
    
I think stackoverflow is for programming questions. –  Sux2Lose Sep 27 '10 at 16:06
add comment

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.