Superversity
← All projects

Data project

Make a chart people can read

Explain how Viet Nam’s urban population share changed from 1990 to 2020. Make a line chart and a short brief that distinguishes what you found from why it happened.

What you’ll finish with

One labeled chart, one sentence on the change in percentage points, and a source note. The brief should make sense to someone who has never seen your sheet.

Build it in 4 steps

  1. Read the unit before charting

    2 hr

    Make

    Import the CSV. Use commas as separators and confirm the population-share column contains numbers. Write down the question and the unit in a worksheet note.

    Check

    You can explain that 35 means roughly 35 out of every 100 people, and your years run from 1990 to 2020.

    LibreOffice · Import a CSV ↗
  2. Calculate the change in share

    2 hr

    Make

    Subtract the 1990 percentage from the 2020 percentage. In the sample as shipped, these are cells B2 and B32. Keep the result in percentage points.

    Check

    Your result is about 16.4 percentage points. Check that year and value rows stayed together if you sorted them.

    World Bank · Indicator definition ↗
  3. Draw a clean line chart

    3 hr

    Make

    Chart year on the horizontal axis and urban population share on the vertical axis. Add a specific title, show the unit, and keep the first and last years readable.

    Check

    The title names the place and time range. Your vertical scale is visible and your sheet contains all 31 years.

    Google Sheets · Line charts ↗
  4. Write a three-sentence brief

    2 hr

    Make

    Name the question, describe the trend and its size, then note that the indicator uses national definitions. Add the World Bank source under the chart.

    Check

    A reader sees a change in share, the year range, and where the numbers came from. A claim about causes would need separate evidence.

    World Bank · Source and methodology ↗