- You are tracking monthly sales for your parts and equipment company in 2019 and 2020. Your monthly sales are as follows with 2019 displayed first followed by 2020:
- January: 2400, 2670
- February 3300, 3100
- March 2700, 1900
- April 1900, 1920
- May 2700, 2450
- June 2650, 3200
- July 3200,1700
- August 1700, 1650
- September 1560, 1649
- October 1890, 1919
- November 2100,2400
- December 3400, 3600
Please create an excel document with the following Table Columns:
|Month||2019 Sales||2020 Sales||Sparklines|
Format your information as a table, and insert a Bar Chart Displaying the monthly profits in dollars. In addition, create a totals row to add the total profits.
- Create a Pie Chart to measure each month of sales in relation to the whole. Add an Image pertaining to Sales next to the chart.
- Place a document header & footer on the worksheet. The Header should be “Monthly Parts Sales”. The Footer should be the Date.