Free demo · Google Sheets · Lesson 3 · Basics · Sort, filter & charts

Sort, filter and chart your data

A list becomes an answer when you put it in order and draw it. Create a filter, sort, then Insert → Chart.

Course | Children | Fees Art | 24 | 36,000 Sport | 31 | 37,200 Computers | 18 | 32,400 Music | 12 | 14,400
  1. 1Data › Create a filter
  2. 2Every heading gets a filter button
  3. 3Children › Sort Z → A: whole rows move together
  4. 4Select two columns › Insert → Chart
  5. ✓A column chart: Sport leads with 31 children
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. Enrol

Tip: press → or Space to step through, ← to go back, R to replay.

About this lesson

Sorting and filtering are the quickest ways to question a list in Google Sheets. Data → Create a filter adds a filter button to every heading; from there you can sort a column A to Z or Z to A, and filter by values or by a condition, and whole rows always stay together. Filter views give each person their own filtered view without disturbing colleagues who share the file. To draw the data, select the labels and the numbers and choose Insert → Chart: Sheets suggests a chart type and opens the chart editor, where Setup chooses the data and chart type and Customize sets titles, colours, labels and the legend. The full course covers tables, dropdowns, pie, line and combo charts, sparklines and dashboards.

Key points

  • Create a filter, then sort and filter by heading
  • Rows stay together when you sort
  • Insert → Chart and the chart editor