Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 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
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 and – yishai Sep 27 '10 at 15:53
I think stackoverflow is for programming questions. – Sux2Lose Sep 27 '10 at 16:06

Your Answer


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.