• 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

    • I really hate it that I can't access the historical changes in my notes and if I accidentally delete large portions of the text which happens more often than not, sometimes, there's no recovering. There should always be a way to go backwards in time, simply because we have iCloud. And why is there no normal export capability? There should be a historical-change-back up and export capability.
    • SeaMonkey 2.53.21 by Razvan Serea The SeaMonkey project is a community effort to develop the SeaMonkey all-in-one internet application suite. Such a software suite was previously made popular by Netscape and Mozilla, and the SeaMonkey project continues to develop and deliver high-quality updates to this concept. Containing an Internet browser, email & newsgroup client with an included web feed reader, HTML editor, IRC chat and web development tools, SeaMonkey is sure to appeal to advanced users, web developers and corporate users. Under the hood, SeaMonkey uses much of the same Mozilla source code which powers such successful siblings as Firefox, Thunderbird, Camino, Sunbird and Miro. Legal backing is provided by the Mozilla Foundation. SeaMonkey 2.53.21 changelog: Unable to load JSON Bookmarks file, Open/Cancel do the same thing bug 1940204. Move replaceVars helper into menu-manager.js for cZ bug 1937379. Remove dumpObject helper from utils.js in cZ bug 1937380. Remove toOpenWindowByType helper from utils.js in cZ bug 1937382. Fix makeLogName helper to not encode twice in prefs.js in cZ bug 1937387. Remove use of escapeFileName helper and tidy up pref_mungeName helper in cZ bug 1937395. Add helper to file-utils.js for ensuring an nsIFile is returned in cZ bug 1937397. Remove unused http.js file from cZ bug 1937890. Remove unused IRC tests from static.js in cZ bug 1937896. Switch from deprecated escape/unescape in cZ bug 1938933. Tidy up use of prefBranch outside of pref-manager in cZ bug 1938935. Make use of pref fallbacks in pref-manager in cZ bug 1938937. Remove unused edit context menu from cZ bug 1939929. Use XPCOMUtils.generateQI in connection-xpcom in cZ bug 1939930. Merge menus.xul, popups.xul and scripts.xul into chatzilla.xul bug 1939958. Make use of toSOutputStream and toSInputStream helpers in DCC code in cZ bug 1939965. Stop hard-coding commandkey for reloadui in cZ bug 1939968. Use suite's FillInHTMLTooltip helper instead of having own version in cZ bug 1939969. Split custom-away from other away/back commands in cZ bug 1942655. Remove ChatZilla Homepage link from Help menu and about command in cZ bug 1942916. Re-arrange toolbar menus in cZ bug 1943783. Remove ChatZilla Homepage link from about and prefs dialogs in cZ bug 1943844. Use custom controller for userlist and tidy up some controller use in cZ bug 1945325. Make use of observes for show/hide elements in cZ bug 1945378. Don't dynamically create focus-input key element in cZ bug 1947028. Remove unused toolbar creation code in cZ bug 1947030. Remove unused updateMenus code from cZ bug 1947031. Clean up whitespaces in cZ package manifest bug 1947040. Remove unused uninstallKeys code from cZ bug 1950002. Use node.remove(), especially instead of node.parentNode.removeChild(node) in cZ bug 1951250. Remove __cz_condition from cZ bug 1951253. Remove outputWindowURL pref from cZ bug 1951256. Remove unused JS tests in cZ bug 1951297. Use includes, startsWith and endsWith instead of indexOf and substr in cZ bug 1951302. Use {} and [] instead of new Object() and new Array() in cZ bug 1951303. Fixup function naming for lint in cZ bug 1955141. Fixup method naming for lint in cZ bug 1955767. Remove old Mozilla 1.0 code from updateAppMotif in cZ bug 1955771. Use throw Components.Exception in cZ bug 1955774. Migrate output-window from HTML to XHTML to make localisation more standard in cZ bug 1955825. Merge munger.js into mungers.js in cZ bug 1956373. Remove unused tagName from mungers.js in cZ bug 1956374. Flatten directory structure in cZ bug 1956375. Tidy up about dialog page in cZ bug 1956376. Add helper to commands.js for sending CTCP commands in cZ bug 1956377. Migrate to standard menus for menu toolbar in cZ bug 1957763. Install plugin dialog broken in cZ bug 1961599. cZ change nick menu not working bug 1962112. Away status isn't reflected correctly in all channels in cZ bug 1962234. Fix dark motif userlist in cZ bug 1967072. SeaMonkey Composer adds moz-do-not-send attribute for links and images bug 1827146. Use menu_Toolbars overlay for navigatorOverlay and console bug 1945335. Remove defunct 2.53 prerelease builds from debugQA extension bug 1947043. Handling of MOZ_LANGPACK_CONTRIBUTORS in defines.inc files should be less custom bug 1951101. Control + U shortcut for underlined text is not working bug 1872514. Context menu search (with default search engine) does not work in the content area of a message compose or SM-Composer window bug 1062092. The following bugs were fixed in our branch of the Gecko source code only: on FreeBSD sqlite3 fails to link for missing math functions bug 1944954. Expand init.configure to use version_package.txt to set MOZ_PKG_VERSION bug 1952757. Change supported msvc Compilers for SeaMonkey 2.53 bug 1954176. SeaMonkey 2.53.21 contains (among other changes) the following major changes relative to SeaMonkey 2.49.5: The Bookmarks Manager has switched its name to Library, and now also includes the History list. When History is invoked, the Library will be shown with the History list selected. The extensive modifications were needed because of Mozilla Gecko platform API changes. Download Manager has been migrated to a new API. Although it looks pretty much the same as before, the search option is missing and some other minor details work differently. The previous downloads history is removed during the upgrade. The layout panel was added to the CSS Grid tools. TLS 1.3 is the default SSL version now. Support for all NPAPI plugins like Flash, Java and Silverlight has been removed. For displaying pdf files in the browser you can use pdf.js-seamonkey from Isaac Schemm. SeaMonkey now uses a new api for formatting regional data like time and date. Default is to use the application locale of the current SeaMonkey build. If you use a language pack or a different OS formatting this is usually not desired. You can change the formatting from the application locale to the regional settings locale (OS) in the preferences dialog under "Appearance". SeaMonkey 2.53.21 uses the same backend as Firefox and contains the relevant Firefox 60.8 security fixes. Download: SeaMonkey 64-bit | Portable SeaMonkey 64-bit ~60.0 MB (Freeware) Download: SeaMonkey 32-bit | Portable SeaMonkey 32-bit View: SeaMonkey Website | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • It doesn't work for the view, but the music gets me every time:  
    • I remember when it first came about and the rubbish that was on it, and I did have a look now and again to see if it improved, and it really did not. I have never downloaded anything from it. Even on my Mac I tend to avoid the store, i prefer to download from source.
    • Are there any others that are as good?
  • Recent Achievements

    • First Post
      Uranus_enjoyer earned a badge
      First Post
    • Week One Done
      Uranus_enjoyer earned a badge
      Week One Done
    • Week One Done
      jfam earned a badge
      Week One Done
    • First Post
      survivor303 earned a badge
      First Post
    • Week One Done
      CHUNWEI earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      428
    2. 2
      +FloatingFatMan
      206
    3. 3
      snowy owl
      194
    4. 4
      ATLien_0
      190
    5. 5
      Xenon
      141
  • Tell a friend

    Love Neowin? Tell a friend!