← Sheets with Martin

Level 3 بريميوم · 7 € مرة واحدة

Chart maker

Format, chart and export. 12 lessons. The first lesson is a preview.

1. Your first chart Select data, Insert → Chart. The chart title says what it is about. ⏱ 22 minutes
2. Number and percent format 1 % is not 1. A spreadsheet has a cell format. ⏱ 20 minutes
3. Print and export File → Download (Sheets) or Save as (Excel). ⏱ 18 minutes
4. Chart types — column, line, pie The same numbers, three views. When a column, when a line, when a pie. ⏱ 20 minutes
5. Axis and legend An axis says what you measure in. A legend says what each colour is. ⏱ 18 minutes
6. Colours and data labels Colour is not random. A label by a column says the exact number. ⏱ 19 minutes
7. A chart from a class survey From raw answers to a table and a column chart. ⏱ 22 minutes
8. Conditional formatting of data A cell turns red itself when a grade or spend crosses a line. ⏱ 21 minutes
9. Sparkline / mini chart A small chart inside a cell — a trend without a big picture. ⏱ 17 minutes
10. Printing more sheets Grades, pocket money and a survey on paper — each sheet right. ⏱ 18 minutes
11. Export to PDF for a teacher One file, readable charts, a name in the file name. ⏱ 20 minutes
12. Chart maker — finale Check the whole Chart maker level and prepare charts for a dashboard. ⏱ 24 minutes

Coding is still on the home page — this course does not replace it.