Question: Excel Homework, Need Help! Painted Paradise On the Documentation worksheet, insert the appropriate content. Fill in any of the other documentation information about the workbook.

Excel Homework, Need Help!Excel Homework, Need Help! Painted Paradise On the Documentation worksheet, insert the

appropriate content. Fill in any of the other documentation information about the

workbook. On the AdvertisingCosts worksheet, create a Line chart of the data

Painted Paradise On the Documentation worksheet, insert the appropriate content. Fill in any of the other documentation information about the workbook. 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 (Right click -> Select Data to edit the Horizontal Axis labels and change to months). Rename the line chart title to Total Advertising Expenses per Month. Change the Vertical Axis minimum to $26,000 (Right click on the Y axis value ranges -> Format Axis) and change the chart style to Style 12 . Move the line chart to a chart sheet and rename the sheet AdvertisingPerMonth. If necessary move the chart sheet to the right of the Advertising Costs sheet. On the Advertising Costs worksheet, create a 3-D Pie chart of the amenities and their 6-month totals in the range A16:B22. Reposition the chart to the right of the semi-annual data. On the 3-D pie chart, insert the title Semi-Annual Advertising Costs. Apply Style 8 to the chart. Add Data Callouts as data labels to the 3-D pie chart. Include the category name and percent in the data labels (Clicking on the addition button inside the chart area or Chart Design > Add Chart Element). On the 3-D pie chart, explode the segment of the chart that was allocated the smallest amount of advertising funds. In cells H5:H11, add sparklines that chart the advertising expenses by amenity type over the months Painted Paradise On the Documentation worksheet, insert the appropriate content. Fill in any of the other documentation information about the workbook. 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 (Right click -> Select Data to edit the Horizontal Axis labels and change to months). Rename the line chart title to Total Advertising Expenses per Month. Change the Vertical Axis minimum to $26,000 (Right click on the Y axis value ranges -> Format Axis) and change the chart style to Style 12 . Move the line chart to a chart sheet and rename the sheet AdvertisingPerMonth. If necessary move the chart sheet to the right of the Advertising Costs sheet. On the Advertising Costs worksheet, create a 3-D Pie chart of the amenities and their 6-month totals in the range A16:B22. Reposition the chart to the right of the semi-annual data. On the 3-D pie chart, insert the title Semi-Annual Advertising Costs. Apply Style 8 to the chart. Add Data Callouts as data labels to the 3-D pie chart. Include the category name and percent in the data labels (Clicking on the addition button inside the chart area or Chart Design > Add Chart Element). On the 3-D pie chart, explode the segment of the chart that was allocated the smallest amount of advertising funds. In cells H5:H11, add sparklines that chart the advertising expenses by amenity type over the months

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!