• 0

Struggling to create graph comparing lap times in Excel


Question

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?

 

post-645-0-48519000-1407354107.png

17 answers to this question

Recommended Posts

  • 0

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.

  • 0
  On 06/08/2014 at 19:47, Nick H. said:

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%.

  On 06/08/2014 at 19:47, zhangm said:

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

  • 0
  On 06/08/2014 at 19:54, Ironman273 said:

This is what I got

attachicon.gifCapture.PNG

Strange.

 

I used the defaults. If you did too, it must be a difference between 2003 and whichever newer version you're using.

  • 0
  On 06/08/2014 at 19:55, Elliot B. said:

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.zipFetching info...

  • 0
  On 06/08/2014 at 19:56, Ironman273 said:

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"?

 

  On 06/08/2014 at 19:56, zhangm said:

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.

  • 0

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 ;)

  • 0
  On 06/08/2014 at 20:06, Ironman273 said:

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...

  • 0
  On 06/08/2014 at 20:06, Elliot B. said:

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)

  • 0
  On 06/08/2014 at 20:08, Ironman273 said:

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 :)

  • 0
  On 06/08/2014 at 20:10, Elliot B. said:

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.zipFetching info...

 

I extended the format to the whole column, added titles to the graph and chart.

  • 0
  On 06/08/2014 at 20:13, Ironman273 said:

I probably clicked on the wrong thing.

 

Try this:

attachicon.gifeb-excellaptimes1.zip

 

I extended the format to the whole column, added titles to the graph and chart.

Thank you! :)

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Seconded on the question. This is otherwise great for testing out systems as well.
    • thanks for that yeah its real its not fake guys i got it of amazon  how do i fix this please the good thing its not fake  
    • Oh Ok thank you,   i'll try to trace which one is the front fans and go from there, i forgot i posted on this issue before oopsy.        But they might already be connected right all i know lol.       I tend to worry way too much i think  
    • //merged your topics as they are the same thing. Same answer as well...    
    • Facebook's mobile app is finally getting support for passkeys by Usama Jawad Companies and social media platforms are embracing passkeys more readily nowadays. Microsoft made new accounts passwordless by default just last month, Windows 11 has supported passkeys for quite a while, and Google hasn't been left behind either. Interestingly, while passkeys work on WhatsApp too, Facebook hasn't enjoyed the same functionality, even though both apps are owned by the same parent company, Meta. Well, that changes today. Meta has announced support for passkeys in Facebook's mobile app. For those unaware, passkeys are essentially an alternative for passwords, as they allow you to sign in to a service securely using the same means that you use to unlock your device. This includes biometric authentication mechanisms such as facial and fingerprint recognition, as well as PIN. Since you don't need to memorize or externally store a complex password, and the methods highlighted above can't be easily duped, you effectively become more secure when you leverage passkeys. Passkeys were developed by the FIDO Alliance, and Meta is a member of this collective too. Apart from highlighting the benefits of passkeys, such as being pretty much immune to phishing and password spray attacks, Meta has revealed that they are coming to the Facebook mobile app on Android and iOS. They will also be arriving on Messenger in the next few months, and both services will share the same passkey for a more streamlined experience. Meta will also allow customers to utilize this passkey to securely autofill payment information when leveraging Meta Pay. Customers can head over to the Accounts Center in the Settings area to create and manage their passkey, or alternatively, they'll also be prompted to create one when they log in to Facebook next. It is important to note that Meta isn't doing away with passwords on Facebook just yet, as all devices may not be compatible with passkeys.
  • Recent Achievements

    • First Post
      TIGOSS earned a badge
      First Post
    • Week One Done
      slackerzz earned a badge
      Week One Done
    • Week One Done
      vivetool earned a badge
      Week One Done
    • Reacting Well
      pnajbar earned a badge
      Reacting Well
    • Week One Done
      TBithoney earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      690
    2. 2
      ATLien_0
      284
    3. 3
      Michael Scrip
      221
    4. 4
      +FloatingFatMan
      197
    5. 5
      Steven P.
      132
  • Tell a friend

    Love Neowin? Tell a friend!