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 an Excel 2010 file like so:

date       time     connections
2010-10-18 08:20:00 38
2010-10-18 08:20:01 71
2010-10-18 08:20:02 67

I want a line graph with the number of connections as the y axis and the second as the x axis.

share|improve this question
    
It looks like you need another column, which calculates the difference between the values in the connections column. So the values would be 38, 33, -4. Is this what you mean? –  sblair Oct 20 '10 at 16:20
    
I want a line graph with the number of connections as the y axis and the second as the x axis. Do I need the difference from one second to the next to accomplish this? –  camomileCase Oct 20 '10 at 18:07

2 Answers 2

Change the format of your data to something like dd:mm:ss, then change the format of the X-axis on the line graph to yyyy-mm-dd hh:mm:ss.

It seems that if the data has the date in it, that gets used as the X-axis scale rather than the time.

share|improve this answer

It appears from your column title that you have the date and time in separate columns. To graph the connections per second over more than one day you will need to merge the date and time into a single datetime value. The simplest way to do that is simply add the the date and time together in another column (assuming your date and time data is correctly formatted and Excel is interpreting them as such).

share|improve this answer

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.