Line chart race – an overview

What is it for?

Use this template to visualize the changing fortunes of people or groups in competition with each other, like political candidates or football teams. Choose between two modes: “Scores”, a line chart which plots the data’s raw values, and “Ranks”, a bump chart which plots rankings.

How to get started

    1
    The first thing you need is a CSV or Excel file of your data
    2
    You need to make sure that there’s a row for each participant in the race – like a candidate or a football team. Populat the first column to populate with the participants’ names. Each other column is a “stage” of the race – like a specific date, week or years.
    name Day 1 Day 2 Day 3
    Lance Armstrong 0 4 7
    Chris Hoyle 0 3 6
    3

    Once you've inputted your data, you should be able to see a preview of your chart in the bottom right corner. If you don't see a preview, you might have to change some of the column settings on the Select columns to visualise panel. Make sure that you add all the columns containing values relevant to your bar chart race to the "Values" setting. You can read more about column settings and adding your own data to a template here.

    4

    To assign an image to each competitor, add an image URL to a column. Under the Data tab, in the Select columns to visualise panel, there’s an Image setting. Assign this setting to the column containing the image URLs you just added. Then switch to the Preview view, and to the right, on the Settings panel, under “Circle styles”, make sure the setting for “Show image in circle” is set to "On". You can read more about adding images to your visualization here.

    5
    Try adding your line chart race to a story and clicking on the axis labels to show different stages of the race in different slides

    6
    You can also experiment with the “zoomed” view to keep the dots representing the competitors in the centre while the axes animate in the background, or with setting the y-axis to being dynamic

Click here to duplicate the example visualization.