Thinkabara

📗 Excel for Beginners · Lesson 9 of 10

Your first chart

Google Classroom

How to make a chart in Excel: a bar chart and a pie chart from a table of expenses.

The tasks in this lesson

1. Bar chart

  1. Select A1 to B6
  2. Click "📊 Bar chart"

💡 Change the Activities amount and watch its bar move right away.

2. Pie chart

  1. Use the same selection, this time click "🥧 Pie chart"

💡 A pie shows parts of a whole. Bars are better for comparing.

All lessons

  1. ✍️ 1. Typing in cellsCells, typing, fixing and deleting
  2. 🎨 2. Format a tableSelect a range, bold and dollar format
  3. 🧮 3. Your first formulaMultiply, add and subtract between cells
  4. ➕ 4. SUM and AVERAGEThe total and the average of a column
  5. ⬇️ 5. Drag and fillThe fill handle, and $ to lock a cell
  6. 🔢 6. MAX, MIN and COUNTThe most, the least, and how many filled in
  7. 🔀 7. IF: if... then...Pass or fail, and COUNTIF
  8. ↕️ 8. Sort a tableHigh to low, and alphabetical
  9. 📊 9. Your first chartA bar chart and a pie chart
  10. 🏠 10. Project: a family budgetEverything we learned in one sheet