1. On the AdvertisingCosts worksheet, create a Line chart of the data for the total spent on advertising each month from January through June. The primary horizontal axis should be the months of the year, and the Vertical (value) Axis should be the total spent on advertising each month. 2. Rename the line chart title to Total Advertising Expenses per Month. Change the Vertical Axis minimum to 26000, and change the chart style to Style 12.
3. Move the line chart to a chart sheet, and rename the sheet AdvertisingPerMonth. If necessary, move the chart sheet to the right of the AdvertisingCosts sheet.
Advertising Expenses
Monthly Data
Amenities January February March April May June
Spa $ 3,200 $ 3,500 $ 3,000 $ 3,200 $ 2,700 $ 2,100
Exercise Facility $ 2,000 $ 2,500 $ 2,000 $ 1,800 $ 1,500 $ 2,000
Golf $ 4,500 $ 5,000 $ 5,000 $ 4,800 $ 5,200 $ 3,000
Banquet Facilities $ 7,000 $ 8,000 $ 7,000 $ 7,250 $ 8,500 $ 8,700
Technology Facilities $ 4,000 $ 3,000 $ 4,000 $ 4,500 $ 4,800 $ 3,500
Community Events $ 3,000 $ 5,000 $ 4,000 $ 3,700 $ 4,200 $ 3,600
Family Events $ 2,700 $ 2,650 $ 2,000 $ 3,500 $ 2,750 $ 4,200
Total $ 26,400 $ 29,650 $ 27,000 $ 28,750 $ 29,650 $ 27,100
Semi-Annual Summary
Amenities Total
Spa $ 17,700
Exercise Facility $ 11,800
Golf $ 27,500
Banquet Facilities $ 46,450
Technology Facilities $ 23,800
Community Events $ 23,500
Family Events $ 17,800
Total $ 168,550