Choosing the Right Chart: Column, Line, Pie or Bar?
All lessons
- Choosing the Right Chart: Column, Line, Pie or Bar?Free
- Column & Bar Charts Done Right: Sorted, Labelled, TitledFree
- Line & Area Charts for Trends: Two Years, One Axis Pro
- Pie & Doughnut Charts: When They Work (and When They Don't) Pro
- Stacked & 100% Stacked Charts: Composition Over Time Pro
- Combo Charts & the Secondary Axis: Revenue and Margin Together Pro
- Scatter Plots & Trendlines: Does Warm Weather Sell Cold Brew? Pro
- Histograms & Distributions: How Big Is a Typical Order? Pro
- Waterfall Charts: The Bridge From Last Year's Profit to This Year's Pro
- Conditional Formatting, Sparklines & a Mini Dashboard Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Read first
In Excel
- Select
A1:B7, then Insert > Charts > Insert Column or Bar Chart > Clustered Column. Alt+F1 inserts the default chart in one step. - Click the chart title to rename it. The + button next to the chart (Chart Elements) turns axis titles, data labels and the legend on and off.
- Insert > Recommended Charts suggests types for your selection. It is a good start, but it does not know the question your chart has to answer.
Loading the spreadsheet…