• 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

    • Microsoft 365 will soon disable outdated authentication protocols for file access by Usama Jawad On a fairly regular basis, Microsoft disables outdated protocols that are used to access its services. In the past few years, the company has deprecated Basic Auth in Exchange Online and cut access to Outlook for third-party apps relying on this protocol. Now, it has decided to get rid of old authentication protocols for file access across Microsoft 365 services. As reported by Bleeping Computer, Microsoft has posted a message on its Microsoft 365 Admin Center. Starting from mid-July 2025, the company will begin disabling legacy authentication protocols used to access files across Microsoft 365 and Office apps, SharePoint, and OneDrive. Essentially, applications or services which use the Relying Party Suite (RPS) or FrontPage Remote Procedure Call (FPRPC) will to perform browser-based authentication to perform open operations on Office files will no longer be able to do so. As expected, this is primarily being done to improve the cybersecurity posture of various services. Microsoft states that RPS can be brute-forced and phished with relative ease as it is fairly outdated. Similarly, FPRPC is typically used for remote web page authoring and it is susceptible to exploitation through various vulnerabilities too. As such, both of these protocols will be disabled by default starting from mid-July 2025, with the rollout of this change targeting completion by August 2025. The Redmond tech giant will update the protocol baseline by default without mandating any licensing changes for customers. In addition, once these modifications are rolled out, Microsoft 365 will require admin consent to get third-party access to files and sites. IT admins can view the guidance available here to configure admin consent workflows. Microsoft says that these changes align with the principles of its Secure Future Initiative (SFI). Earlier today, it announced the rollout of improved security defaults for Windows 365 citing the same reasons too.
    • It does and it can... I took an i3 board and upgraded it to my FX8350... no issues, just put in new drivers over the top that Windows didn't. Not the issue for me, (though I eventually did do a new install from 23H2 to 24H2)... I was on 22H2 at the time. The issue is activation. You may get hit with having to activate again.
  • 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
      707
    2. 2
      ATLien_0
      283
    3. 3
      Michael Scrip
      218
    4. 4
      +FloatingFatMan
      197
    5. 5
      Steven P.
      130
  • Tell a friend

    Love Neowin? Tell a friend!