Lesson 4.5: Creating Charts (Bar, Pie, Line)
Charts are used to visually represent data, making it easier to understand trends and comparisons. In Excel or Google Sheets, you can quickly convert your data into different types of charts.
📊 Why Use Charts?
-
Makes data easier to understand
-
Highlights patterns and trends
-
Useful for reports and presentations
🪄 Steps to Create a Chart:
-
Select the data you want to chart (including headings).
-
Go to the Insert tab.
-
Choose a Chart type (Bar, Pie, Line, etc.).
-
Customize chart title, labels, and colors as needed.
📈 Common Types of Charts:
1. Bar Chart
-
Best for comparing values across categories.
-
📊 Example: Comparing monthly sales of 3 products.
2. Pie Chart
-
Shows parts of a whole as percentages.
-
📊 Example: Percentage of expenses in a budget.
3. Line Chart
-
Shows trends over time.
-
📊 Example: Daily temperature over a week.
🧾 Example Table for Practice:
| Product | Jan | Feb | Mar |
|---|---|---|---|
| A | 100 | 120 | 90 |
| B | 80 | 95 | 110 |
| C | 60 | 70 | 85 |
Use this data to create:
-
A bar chart comparing monthly sales
-
A line chart for Product A over 3 months
-
A pie chart of total sales per product
📝 Practice Task:
-
Enter your own data in a table (e.g., expenses, marks, sales).
-
Try creating different types of charts.
-
Customize chart titles and labels.
-
Observe which chart best suits your data.
✅ Tip: Use charts in presentations, reports, and office documentation to impress your employer or clients.