Create a Monthly Sales Report using the following structure:
|
Month |
Product A |
Product B |
Product C |
Total Sales |
|
January |
50000 |
35000 |
25000 |
|
|
February |
60000 |
42000 |
30000 |
|
|
March |
75000 |
50000 |
38000 |
|
|
April |
68000 |
47000 |
35000 |
|
|
May |
82000 |
55000 |
42000 |
Students Must Practice
- Create an Excel Table.
- Apply a Table Style.
- Use the Total Row.
- Create a Column Chart.
- Create a Bar Chart.
- Create a Line Chart.
- Create a Pie or Doughnut Chart.
- Try a Combo Chart.
- Format the chart with a title and data labels.
- Use Recommended Charts.
Final Task
Create a professional Sales Chart Report that clearly presents the monthly sales data.