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.