Lesson 9: Your first chart
- Select A1 to B6
- Click "📊 Bar chart"
| A | B | |
|---|---|---|
| 1 | Expense | Amount |
| 2 | Food | 2400 |
| 3 | Electricity | 450 |
| 4 | Gas | 800 |
| 5 | Activities | 600 |
| 6 | Fun | 350 |
- A bar chart of A2:B6
All lessons
✍️ 1. Typing in cells
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
How to make a chart in Excel: a bar chart and a pie chart from a table of expenses. Change the Activities amount and watch its bar move right away. A pie shows parts of a whole. Bars are better for comparing.
Explore more: Excel course: all lessons, and Project: a family budget.