• 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

    • ...if there is any question if it's fake ... Steve Gibson created a little program to detect fraudulent drives.   https://www.grc.com/validrive.htm
    • Hello   Would anyone know by chance regarding the Lian Li Lancool 216 ARGB/Fan hub specifically where the front fans would connect to, to be able to see there RPM in UEFI bios when setting up the fan curves,   i am not a hardware expert, mostly a noob on Hardware still,  trying to learn as much as i can, but its a slow process. Did get Dust clean out done on system, and Temps are much much better,  even during a Defender scan previously i'd hit 85C or higher at times, today despite RL temp being humid and warmer today a bit,  didn't hardly go over 60C.     So i definitely cleaned system good this time!! Did the clean out after early afternoon storms ended!! **Note did not build system myself, had Ibuypower Build my Dream Ryzen Build, normally i don't mention that part as sometimes i feel ashamed that i can't build a whole system myself**  Even my last system before this one had Local PC shop build that one, it ran ok, but even after getting the upgraded cooler installed they said this should work,    still throttled when doing tasks.     My AMD Never Throttles!! I also tend to worry alot, just my nature i guess  
    • Did you just buy this drive? Were you ever able to use the full capacity, or you bought this new/only shows 3 GB? If this is new, then you probably got a fake.
    • Steam overlay's FPS counter gets major upgrade to show CPU and VRAM usage, temps, and more by Pulasthi Ariyasinghe Valve has been steadily revamping its Steam client for years now, with major updates hitting the PC store and platform targeting various parts. The next target has been revealed to be the very popular performance monitor that's a part of the Steam overlay. While the current version only shows a number in a small area to count the current frame rate of the game that's running, the update is giving much more information to the user. Now available via the Steam Beta client, the performance monitor now has multiple detail levels to choose from. These are FPS Single Value (the original version), FPS Detail & Graph, FPS Detail CPU & GPU Utilization, as well as the behemoth FPS Detail & Graph, CPU, GPU, & RAM Details options. As expected, each option adds more and more information to what's shown to the user on the overlay. Screen position, contrast and saturation, as well as background opacity, can also be adjusted from the same overlay settings page. The image above shows the maximum detail option available for users, with everything from generated frames to helpful graphs and VRAM information being shown while playing a game. "The performance monitor can help you understand your frame rate (both including frame generation, and base game frame rate), and it can help you see if CPU utilization might be your bottleneck, or if your GPU is," says Valve regarding its latest upgrade. "You can see if you are out of system or video memory and if those factors are impacting performance as well." Valve said that some of these features, in this initial beta release, will only be available on Windows machines, at least for now. "Much of it will apply to other supported operating systems and while some metrics are not supported on other operating systems additional support is planned for later," added the company. Check out this handy FAQ set up by Valve that explains what each setting means as well as notes on what issues players can diagnose, like micro stutter or bottlenecks, using these overlay additions. To try out the new feature before it goes out to everyone, you can switch to the Steam Beta Client by heading to the app's Settings > Interface section and changing the Client Beta Participation dropdown to the latest version available. Following that, to enable the new performance monitor, go to Settings > In Game section, and change the detail level to the level you would like.
    • I actually didn't like the classic Start Menu as much as the XP, Vista, 7 style menu. Mainly didn't like how you either had to click Programs every time, when that is what you would want 95% of the time, or fill up that top section (I forget what it was called back then) which was both harder than it should have been and looked ugly.
  • 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
      675
    2. 2
      ATLien_0
      284
    3. 3
      Michael Scrip
      219
    4. 4
      +FloatingFatMan
      196
    5. 5
      Steven P.
      133
  • Tell a friend

    Love Neowin? Tell a friend!