Charts
Pick the right chart and make it clear: columns, lines, pies, combos, scatter plots and more.
Lessons
In the order the Roadmap teaches them.
In the full course. Confident · 10 min
Pick the right chart
Choose a chart by the question it answers (a trend, a comparison, a share or a relationship) and insert it.
See the lessonIn the full course. Confident · 9 min
Column and bar charts
Turn a small table into a column chart, give it a title and labels, and know when a bar chart reads better.
See the lessonIn the full course. Confident · 8 min
Line charts for trends
Turn monthly numbers into a line chart that shows the trend, compare two years on one chart, and know when a line beats columns.
See the lessonIn the full course. Confident · 9 min
Pie and donut charts (and when not to)
Show parts of a whole with a pie or doughnut chart, and switch to bars when there are too many slices to compare.
See the lessonIn the full course. Confident · 9 min
Titles, labels and legends
Make a chart explain itself with a clear title, an axis title for the unit, a legend in the right place and data labels where exact numbers matter.
See the lessonIn the full course. Confident · 9 min
Colors and styles
Choose the colors of a chart's series so the one that matters stands out and the rest stay quiet.
See the lessonIn the full course. Confident · 10 min
Charts that update automatically
Set up a chart so a new row of data shows up in it without rebuilding the chart.
See the lessonIn the full course. Confident · 9 min
Combo chart: columns plus a line
Show actual amounts as columns and a target or limit as a line on one chart, and know when the two don't belong on the same axis.
See the lessonIn the full course. Confident · 8 min
SPARKLINE function
Draw a tiny chart in a cell with SPARKLINE, choose a column or win/loss chart, and fill it down to give every row its own.
See the lessonIn the full course. Advanced · 10 min
Secondary axis
Put a series with small numbers, like a percent, on its own axis on the right so two different kinds of numbers share one chart.
See the lessonIn the full course. Advanced · 9 min
Scatter plot with a trendline
Plot two columns of numbers as a scatter chart, add a trendline, and read what the line does and does not tell you.
See the lessonIn the full course. Advanced · 10 min
Histogram
Turn a column of numbers into a histogram that shows how many values fall in each range, and read its shape.
See the lessonIn the full course. Advanced · 9 min
Waterfall chart
Chart how an opening balance turns into a closing balance, one rise and one fall at a time.
See the lessonIn the full course. Advanced · 10 min
Gantt chart from a task list
Turn a list of jobs with start days and lengths into a Gantt chart, one bar per job, so you can see what overlaps.
See the lessonPaths with these lessons
A path is a short list of lessons from the course, picked for one goal.
Google Sheets basics in a weekend
For starting from zero, or only typing numbers into cells today.
14 lessons · about 2 h · 4 free · Beginner to Confident
See the pathPivot tables by Monday
For summarizing a sales or expense list for a meeting.
7 lessons · about 1 h 5 min · 1 free · Confident
See the pathGet the full course
Every lesson in the Google Sheets course, with new lessons added as they're written.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Excel course for US$49.