Assignment: You are provided with a dataset that includes sales performance across different regions over the past five years. Your task is to create multiple charts in Excel to visualize the trends and patterns in the data. You will generate a minimum of four different types of charts to analyze and compare the sales data. Need Assignment Help?
Dataset (Example):
| Year |
Region A |
Region B |
Region C |
Region D |
| 2020 |
50000 |
40000 |
45000 |
35000 |
| 2021 |
60000 |
42000 |
46000 |
37000 |
| 2022 |
65000 |
45000 |
50000 |
40000 |
| 2023 |
70000 |
48000 |
52000 |
45000 |
| 2024 |
75000 |
50000 |
55000 |
47000 |
Requirements:
1. Line Chart:
Create a line chart to show the sales trend for each region from 2020 to 2024. Make sure each region is represented by a separate line, and use different colors for clarity.
2. Bar Chart:
Generate a bar chart that compares the sales performance of the four regions in the year 2024. Display the regions on the x-axis and the sales numbers on the y-axis.
3. Pie Chart:
Use a pie chart to represent the total sales contribution of each region in 2024. Ensure that the percentages are clearly labeled on the pie segments.
4. Stacked Column Chart:
Create a stacked column chart to visualize the total sales for all regions combined from 2020 to 2024, with each year having a breakdown of how much each region contributed to the total sales.