Assignments for Class 5: Working with Charts and Graphs

Assignments for Class 5: 

Working with Charts and Graphs

Assignment 1: Creating a Column Chart

Task: Use the following sales data for products across 4 years and create a Column Chart.

Year	Product A Sales	Product B Sales	Product C Sales
2019	12,000	10,000	8,500
2020	15,500	11,000	9,200
2021	17,000	13,000	10,300
2022	20,000	14,500	12,400

Steps with Solution:

1. Step 1: Select the Data Range.
• Highlight the data range from A1 to D5, including headers for years and product names.
2. Step 2: Insert a Column Chart.
• Go to the Insert tab in the ribbon.
• In the Charts group, click on Insert Column or Bar Chart and select Clustered Column.
3. Step 3: Customize the Chart.
• Add a Chart Title: "Sales Comparison of Products (2019-2022)".
• Click on the chart, go to Chart Elements (green "+" icon), and check the Chart Title box.
• Type the title in the chart.
• Add a Legend: Right-click on the chart and click on Add Legend. Choose the position for the legend (e.g., right).
• Add Data Labels: Click on Chart Elements, and check the Data Labels box to display sales figures on each bar.
4. Step 4: Analyze the Data.
• The chart will show how Product A, B, and C sales have increased over the years. You can see that Product A had the highest growth, while Product C had the lowest growth.

---

Assignment 2: Creating a Line Chart

Task: Create a Line Chart for the following data to show the trend in revenue for two stores over 6 months.

Month	Store X Revenue	Store Y Revenue
January	5,000	4,000
February	6,000	5,500
March	7,200	6,000
April	8,500	7,200
May	9,800	8,000
June	10,500	9,500

Steps with Solution:

1. Step 1: Select the Data.
• Highlight the data range from A1 to C7 (including headers).
2. Step 2: Insert a Line Chart.
• Go to the Insert tab → Click on Insert Line or Area Chart → Select Line with Markers.
3. Step 3: Customize the Chart.
• Add a Chart Title: "Monthly Revenue Trends (Store X vs Store Y)".
• Follow the steps for adding a chart title as in Assignment 1.
• Add Data Labels to show the revenue figures for each point on the line.
• Customize the Legend to differentiate between Store X and Store Y.
4. Step 4: Analyze the Data.
• Store X consistently generates more revenue than Store Y, but both stores show a steady upward trend in revenue over the months.

---

Assignment 3: Creating a Pie Chart

Task: Create a Pie Chart based on the following distribution of market share for different companies in 2023.

Company	Market Share (%)
Company A	40%
Company B	30%
Company C	20%
Company D	10%

Steps with Solution:

1. Step 1: Select the Data.
• Highlight the range A1 to B5 (Company names and market share).
2. Step 2: Insert a Pie Chart.
• Go to the Insert tab → In the Charts group, click Insert Pie or Doughnut Chart → Select Pie.
3. Step 3: Customize the Chart.
• Add a Chart Title: "Market Share Distribution (2023)".
• Add Data Labels to display the percentage for each slice of the pie.
• You can also pull out one of the slices (e.g., Company A) to create a "Exploded Pie Chart" to emphasize its higher market share.
4. Step 4: Analyze the Data.
• The Pie Chart clearly shows that Company A has the largest market share, followed by Company B and Company C.

---

Assignment 4: Creating a Bar Chart

Task: Use the following data to create a Bar Chart to compare the average test scores for three subjects in two different classes.

Class	Math	Science	English
Class A	75	85	78
Class B	82	80	88

Steps with Solution:

1. Step 1: Select the Data.
• Highlight the range A1 to D3.
2. Step 2: Insert a Bar Chart.
• Go to the Insert tab → In the Charts group, click Insert Bar Chart → Select Clustered Bar.
3. Step 3: Customize the Chart.
• Add a Chart Title: "Average Test Scores (Class A vs Class B)".
• Add Legends to distinguish between Math, Science, and English scores.
• Add Data Labels to display the actual scores on the bars.
4. Step 4: Analyze the Data.
• The bar chart shows that Class B performed better in Math and English, while Class A had higher scores in Science.

---

Assignment 5: Advanced Chart Customization

Task: Create a Combination Chart for the following data, where you represent Product A sales as a Column Chart and the Total Sales as a Line Chart.

Year	Product A Sales	Total Sales
2019	8,000	15,000
2020	10,500	18,000
2021	12,000	20,500
2022	14,500	25,000

Steps with Solution:

1. Step 1: Select the Data.
• Highlight the range A1 to C5.
2. Step 2: Insert a Combo Chart.
• Go to the Insert tab → In the Charts group, click Insert Combo Chart → Select Clustered Column - Line on Secondary Axis.
3. Step 3: Customize the Chart.
• Add a Chart Title: "Product A Sales and Total Sales (2019-2022)".
• Customize the chart by labeling the Y-axis for the line chart (Total Sales) and the X-axis for the column chart (Product A Sales).
• Add Data Labels for both the column and line data points.
4. Step 4: Analyze the Data.
• The combination chart shows how Product A sales have increased over the years and how they contribute to the overall total sales.

---

Summary of Assignments

1. Column Chart: Compare multiple products' sales over time.
2. Line Chart: Visualize trends in revenue for two stores.
3. Pie Chart: Show market share distribution among companies.
4. Bar Chart: Compare test scores across different subjects for two classes.
5. Combo Chart: Represent sales data with both columns and lines for advanced analysis.