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
Sparklines
Draw a tiny chart beside each row of numbers, mark its high and low months, and pick the type that fits.
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.
Get the full course
Every lesson in the Excel course, with new lessons added as they're written.
- All 217 Excel lessons open today, and every new one as it's written.
- The Roadmap, Skills and all eight paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Google Sheets course for US$49.