How to Plot a Line Chart Using Lap Times in Milliseconds in Google Sheets

A Line chart is easy to plot if the data series are correctly formatted. Here are the things you must know before trying to plot a Bar, Column or Line chart using lap times in milliseconds in Google Sheets.

Please note that the below points are applicable to any chart that uses milliseconds as data series or even in a calculation.

  1. Make sure that you have entered the lap times in the proper millisecond format. I mean it must be in HH:MM:SS.000 format.
  2. If the lap times are formatted like MM:SS.000 (probably you have), you can use a formula to format it correctly. Attempting to format using the Format menu won’t help you. I have explained this in the later part of this post.

When it comes to plotting charts, data formatting is an art in Spreadsheet applications like Google Sheets.

I have given special attention to this in my earlier chart related tutorial here – How to Format Data to Make Charts in Google Sheets.

In the above-shared guide, I didn’t include how to format the data series. My focus was mainly on the data orientation and order.

In this Google Sheets tutorial, let me help you to plot a line chart using lap times in milliseconds in Google Sheets.

As a side note, the same formatting is also applicable to Bar/Column graphs.

Formatting the Lap Times to Create a Line Graph

As I have said above, MM:SS.000 is wrong formatting of the lap time. It looks like a correct format. But Google Sheets will treat these time values as pure text.

Lap times in wrong format to create line graph

If your lap times are entered in the above format, you must convert that to HH:MM:SS.000 format. How?

In the beginning, I’ve mentioned about a formula to do that. find that in this guide – How to Format Time to Millisecond Format in Google Sheets.

The formatted data must look like as below. That means you must include the hours’ digit “00:” with the lap times.

Lap times in correct format to create line graph

Using this data you can easily plot a Line graph in Google Docs Sheets. See the below step by step instructions.

Steps to Create a Line Chart Using Lap Times in Milliseconds Format

Step 1: Data Selection and Nature of the Data.

Select the data in the array A1:C6. In this, column A contains the circuit numbers, column B and C contains the time taken by the first and second driver in each circuit respectively.

Step 2: Chart Editor Panel Settings.

Open the chart editor panel. To open, go to Insert > Chart. Then select the chart type that you want. You can look that for under the “Setup” tab.

Recommended chart types are Column, Bar or Line chart. I am creating a Line chart here.

Step 3: Other Chart Settings.

Make sure that the other settings under the “Setup” tab are as as follows. Google Sheets will automatically set these correctly. If not, adjust it manually.

Details of the settings under the chart editor SETUP tab

Step 4: Finished Chart.

Example Line chart using lap times in milliseconds

Follow the above instructions to create a Line chart using lap times in milliseconds format in Google Sheets.

Chart Related Tips and Tricks:

  1. How to Get Dynamic Range in Charts in Google Sheets.
  2. Get a Target Line Across a Column Chart in Google Sheets.
  3. How to Create a Multi-category Chart in Google Sheets.
  4. How to Move the Vertical Axis to Right Side in Google Sheets Chart.
  5. Bar or Column Chart with Red Colors for Negative Bars in Google Sheets.
Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Lookup Values Under Categories in Excel and Google Sheets

We can use a combination of XLOOKUP and VLOOKUP in both Excel and Google...

Extract Items Under a Category from the Same Column in Excel

In Excel, you can use a combination of the XLOOKUP and DROP functions to...

How to Create a Searchable Table in Excel Using the FILTER Function

Finding specific records, or rows containing the required information, is straightforward in Excel using...

Time Sequences in Excel by Minute, Hour, or Second Increments

Creating time sequences, whether by hour, minute, or second increments in Excel, can be...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

1 COMMENT

  1. Hiya, nice post thank you. Can you help, my charts lose the info when shared or published and can’t chart the lap times in data studio either?

    Many thanks

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.