Creating Line Charts

This tutorial uses Google spreadsheets to create a line chart.

There is sample data for this tutorial here .

So let’s create a line chart. Let’s say we want to see how healthcare expenditure evolved in Luxembourg, our top spending country.

  1. Go back to your World Bank data sheet.

  2. Remove the filter for years and filter for a single country: Luxembourg (you can do so by clicking the “clear” label in the filtering menu – then type Luxem and you’ll see Luxembourg appear – select it).

  3. Now the only thing that’s left is sorting by years – so you have them in right order.

  4. Select all of it and copy it to a new sheet.

  5. Now move the columns year and “healthcare expenditure total per person” next to each other.

    https://i2.wp.com/farm9.staticflickr.com/8305/7982104847_5a4be76fc7_o_d.png

  6. Select both columns and select “Chart…” from the “insert” menu.

  7. Click on the “charts” tab and select the line chart you want to plot.

    https://i1.wp.com/farm9.staticflickr.com/8330/8079886985_49583d3d90_o_d.png

  8. You already know how to manipulate the look of a chart, so go and play around until it looks similar to the chart above!

Any questions? Got stuck? Ask School of Data!

Last updated on Sep 02, 2013.