=%₹#A1✦▦✓Σfx
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
- 1Data › Create a filter
- 2Every heading gets a filter button
- 3Children › Sort Z → A: whole rows move together
- 4Select two columns › Insert → Chart
- ✓A column chart: Sport leads with 31 children
Which course is the most popular? Let's ask the data.
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