• 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.zip 15.38 kB · 32 downloads

  • 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

    • Hello Could you be kind too help me fix this 3.1gig and not 256gig it says 3.1gig only .someone told me to fix it with this https://www.disk-partition.com/articles/64gb-flash-drive-only-showing-32gb-5740i.html yes my sandisk ultra usb 3.0 256gb wont show up in full .  but i don't know want options i have to use on there can someone  please guide me with step by step instructions please  guide me with step by step instructions on how to repair this .sorry for asking but I've tried but i don't know want i have to do on that programme please help me i am on windows 11 home thank you nick
    • AI is as big a scam as FTX was...run by the same 'group' of people as well.
    • Slack Business+ plan jumps to $15/month as AI features launch by Paul Hill Salesforce has announced a price increase for one of its plans, which will add a few dollars per user each month to organizations' bills. The Slack Business+ plan will see prices rise from $12.50 to $15 per user per month if you pay for a whole year up front; if you pay monthly, the bill will increase from $15 to $18. Salesforce has kept the prices of its Pro plan the same and introduced a new Enterprise+ plan with custom prices for larger organizations. The new price adjustments will take effect on August 17 if you’re planning to renew, and immediately for any new customers. So, if you are renewing before August 17, you will be able to delay this price rise for around a year. The company isn’t just pulling a fast one on customers with these price rises. It’s adding AI to all paid plans, so if you use these features, the increase somewhat justifies them. We saw a similar tactic from Google Workspace back in January. New AI features and deeper Salesforce integration Slack has outlined all the new AI features coming to its Pro, Business+, and Enterprise+ plans starting from July 17. The Pro Plan will have access to conversation and thread summaries, plus huddle notes, while Business+ will have all of those plus: AI Search, Recaps, Translations, File summaries, Workflow generation, and Summarize channels workflow step. The Enterprise+ subscription has all those AI features plus Enterprise search. Additionally, it provides enhanced security, admin controls, governance, and compliance. The company also announced that all plans, including the free plan, will get access to Salesforce Channels, which lets you use Slack and Salesforce together directly within their Customer 360 Apps. Who benefits? By embedding AI right within Slack, organizations should be able to boost efficiency more easily in their daily operations. To ensure that it keeps up with the competition, the company is investing significant resources into its research and development to deliver new innovations. Affected organizations will need to try to find effective ways to use these AI tools to make the price increase worth it, whether this is speeding up tasks to free workers up for other work or something else. The move definitely doesn’t hurt Slack because it’ll make more money whether you use these AI tools or not.
    • Which illegal products? I am asking for a friend.
    • Not having a backup on Earth and another on the moon and another on Mars is also a redundancy failure. Not having a backup in another galaxy is a redundancy failure
  • Recent Achievements

    • 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
    • First Post
      xuxlix earned a badge
      First Post
    • First Post
      Tomek Święcicki earned a badge
      First Post
  • Popular Contributors

    1. 1
      +primortal
      670
    2. 2
      ATLien_0
      288
    3. 3
      Michael Scrip
      224
    4. 4
      +FloatingFatMan
      195
    5. 5
      Steven P.
      144
  • Tell a friend

    Love Neowin? Tell a friend!