Elliot B. Posted August 6, 2014 Share Posted August 6, 2014 I have 26 lap times of a go karting course. When I select them all and create a standard line chart, it doesn't show what it's clear I'm trying to show. Screenshot included below. Any ideas? Link to comment Share on other sites More sharing options...
0 zhangm Supervisor Posted August 6, 2014 Supervisor Share Posted August 6, 2014 Post the file? Otherwise, try adding headers (Lap, Time) to your columns and selecting those with your data when you're making the chart. Link to comment Share on other sites More sharing options...
0 Nick H. Supervisor Posted August 6, 2014 Supervisor Share Posted August 6, 2014 It might help if you explain what you've tried in order to get the graph in the screenshot. From the looks of things you've selected all of column B, but only one cell from column A (A26). All of column A should be your X axis, and all of column B should be your Y axis (if I understand what you're trying to achieve correctly.) EDIT: Yes, you could post the file as well so that we can try it on our own machines. Link to comment Share on other sites More sharing options...
0 Elliot B. Posted August 6, 2014 Author Share Posted August 6, 2014 It might help if you explain what you've tried in order to get the graph in the screenshot. From the looks of things you've selected all of column B, but only one cell from column A (A26). All of column A should be your X axis, and all of column B should be your Y axis (if I understand what you're trying to achieve correctly.) No, I selected A1 to B26, 100%. Post the file? Otherwise, try adding headers (Lap, Time) to your columns and selecting those with your data when you're making the chart. Tried adding headers, didn't change anything. Here is the file: http://speedy.sh/tfyP3/eb-excellaptimes1.xls Link to comment Share on other sites More sharing options...
0 Ironman273 Posted August 6, 2014 Share Posted August 6, 2014 This is what I got Link to comment Share on other sites More sharing options...
0 Elliot B. Posted August 6, 2014 Author Share Posted August 6, 2014 This is what I got Capture.PNG Strange. I used the defaults. If you did too, it must be a difference between 2003 and whichever newer version you're using. Link to comment Share on other sites More sharing options...
0 Ironman273 Posted August 6, 2014 Share Posted August 6, 2014 I'm using 2013. All I had to do was delete series 1, which it took as the lap numbers. Once I did that it immediately looked like my screencapture. Link to comment Share on other sites More sharing options...
0 zhangm Supervisor Posted August 6, 2014 Supervisor Share Posted August 6, 2014 Strange. I used the defaults. If you did too, it must be a difference between 2003 and whichever newer version you're using. I just converted it all into seconds. Book1.zip Link to comment Share on other sites More sharing options...
0 Elliot B. Posted August 6, 2014 Author Share Posted August 6, 2014 I'm using 2013. All I had to do was delete series 1, which it took as the lap numbers. Once I did that it immediately looked like my screencapture. How do I delete "series 1"? I just converted it all into seconds. How do I do that? "Time" in Format Cells doesn't allow me to choose seconds with 3 decimal places. Link to comment Share on other sites More sharing options...
0 Ironman273 Posted August 6, 2014 Share Posted August 6, 2014 Well, here's my version eb-excellaptimes1.zip and this was my format for that cell range Link to comment Share on other sites More sharing options...
0 Nick H. Supervisor Posted August 6, 2014 Supervisor Share Posted August 6, 2014 Here's what I get in Calc: Mine seems to be possible by adding "Time" and "Lap" and then using those as the labels for the graph. Link to comment Share on other sites More sharing options...
0 Elliot B. Posted August 6, 2014 Author Share Posted August 6, 2014 As soon as I enter 00:25:918, it changes it to 12:00:26 AM in all of your files -_- Link to comment Share on other sites More sharing options...
0 Ironman273 Posted August 6, 2014 Share Posted August 6, 2014 My format only goes until the last lap. I didn't apply it to the columnn. Also, I typed it all in myself, so I can't be sure there aren't typos. I wasn't going to download an .exe from that site ;) Link to comment Share on other sites More sharing options...
0 Elliot B. Posted August 6, 2014 Author Share Posted August 6, 2014 My format only goes until the last lap. I didn't apply it to the columnn. Also, I typed it all in myself, so I can't be sure there aren't typos. I wasn't going to download an .exe from that site ;) It downloads it as the orignal file, not an exe... Link to comment Share on other sites More sharing options...
0 Ironman273 Posted August 6, 2014 Share Posted August 6, 2014 It downloads it as the orignal file, not an exe... Well, it downloaded a file that was "filename.xls.exe" so I cancelled it. Also, if you use my format like the screenshot above you can apply it to the column and then input it as "0:25.918" (notice the leading zero, the colon and the decimal point) Link to comment Share on other sites More sharing options...
0 Elliot B. Posted August 6, 2014 Author Share Posted August 6, 2014 Well, it downloaded a file that was "filename.xls.exe" so I cancelled it. Strange, that doesn't happen on this end. Or for the guys above, it seems. Oh well :) Link to comment Share on other sites More sharing options...
0 Ironman273 Posted August 6, 2014 Share Posted August 6, 2014 Strange, that doesn't happen on this end. Or for the guys above, it seems. Oh well :) I probably clicked on the wrong thing. Try this: eb-excellaptimes1.zip I extended the format to the whole column, added titles to the graph and chart. Link to comment Share on other sites More sharing options...
0 Elliot B. Posted August 6, 2014 Author Share Posted August 6, 2014 I probably clicked on the wrong thing. Try this: eb-excellaptimes1.zip I extended the format to the whole column, added titles to the graph and chart. Thank you! :) Link to comment Share on other sites More sharing options...
Question
Elliot B.
I have 26 lap times of a go karting course.
When I select them all and create a standard line chart, it doesn't show what it's clear I'm trying to show.
Screenshot included below.
Any ideas?
Link to comment
Share on other sites
17 answers to this question
Recommended Posts